How to add filters in Power BI [EASY STEPS]

Microsoft for Business » Power BI

Reading time icon 2 min. read

Calendar icon Updated on

by Milan Stanojevic 

updated on

Share this article

Readers help support Windows Report. We may get a commission if you buy through our links. Tooltip Icon

Read our disclosure page to find out how can you help Windows Report sustain the editorial team Read more

When it comes to organizing and visualizing various sets of data, Power BI is definitely up to the challenge. Still, that doesn’t mean the program is problem-free for some people.

Quite a few users reported issues with adding filters in Power BI:

I am trying to enable filter pane for my existing Power BI report. I followed the which are mentioned in the link. But I did not see any Filter Pane on the report page after enabling the filter pane option. But I see on New Power BI file.

So, the tutorial from Microsoft didn’t help, because the OP didn’t see any Filter Pane in the Power BI. If you’re in the same situation, here are some additional solutions that you can use.

Steps to add filters in Power BI

1. Turn on new filters for all new reports

  1. In Power BI Desktop, click on File.
  2. Select Options and Settings, and then Options.power bi options filter
  3. Select Preview Features, and then select the New filter experience checkbox.
  4. Restart Power BI Desktop.
  5. After you restart Power BI Desktop, the filters should be enabled by default for all new reports.

Learn everything there is to know about Power BI from our in-depth article!

2. Turn on new filters for an existing report

  1. In Power BI Desktop in an existing report, select File.
  2. Select Options and Settings, then Options.
  3. Select Report Settings under the Current File category.
  4. Check Enable the updated filter pane, and show filters in the visual header for this report from under Filtering experience.

power bi report settings filtering experience

Conclusion

As you can see, you only need to change certain options to make your filtering work, because the filter pane is not present in Power BI by default.

If for some reason you don’t want filters, just click again on Enable the updated filter pane, and show filters in the visual header for this report to disable the filter pane.

Did you find these methods useful? How do you use filters in Power BI? Do let us know in the comments section below!

RELATED STORIES YOU NEED TO CHECK OUT:

Milan Stanojevic

Milan Stanojevic Shield

Windows Toubleshooting Expert

Milan has been enthusiastic about technology ever since his childhood days, and this led him to take interest in all PC-related technologies. He's a PC enthusiast and he spends most of his time learning about computers and technology. Before joining WindowsReport, he worked as a front-end web developer. Now, he's one of the Troubleshooting experts in our worldwide team, specializing in Windows errors & software issues.