How to disable filters in Power BI [STEP-BY-STEP GUIDE]

2 minute read
power bi disable filters

Home » How To » How to disable filters in Power BI [STEP-BY-STEP GUIDE]

Filtering data in Power BI is the main feature for people who want to visualize various sets of information. It is an interactive tool which usually doesn’t bring many issues.

However, there are some instances in which you don’t need a filter. Quite a few users reported issues with disabling a filter in Power BI and today we will show you what it needs to be done to solve them.

One user described the following issue on the official forum:

I have a problem with filtering. What I want to do to have a chart like below showing a trend of Sales and expense and have a dynamic timeline to adjust the dates on the chart. BUT I want to show an expense percentage of sales for 2015/2016 on a card unaffected by timeline visuals.

So, the automatic filtering on visuals poses a problem for the OP.

 

This is not the only issue encountered by users. Another one reported the following:

I have a multi-page report that I publish to the web each week for upper managment. I have received a request from them to have the ability to disable all of the lines values except one of them. Basically, they want the ability to toggle the line values in a graph on and off similar to the way you would toggle values in a slicer. Is this possible? For example, in the image below, they would like to toggle on/off any or all values in the legend. And, this must be done via the published WebUI. Is it possible?

The OP of this thread wants to disable all lines except one. It is worth mentioning that the operation must be done through the published WebUI.

power bi filter chart example

Steps to disable filter in Power BI

1. Use the Edit interactions feature

For the first issue, here are the steps you need to follow:

  1. Click on the timeline visual in your scenario.
  2. Turn on Edit interactions under the Format ribbon.
  3. Choose None in the Card visual.power bi filter

So, a little twitch in the settings solved this issue, but different cases may have different solutions. So, now we explore another issue described by a Power BI user.


This guide will make you a better Power BI user. Check it out now!


2. Write a new measure

For the second example, you need to write a new measure in DAX that returns BLANK () based on the selection from a slicer.

power bi filter new measure

Conclusion

So, here you have it. You can disable filters in more ways than one. Now, all depends on your project.

How do you disable filters in Power BI? Do let us know in the comments section below.

RELATED ARTICLES YOU NEED TO CHECK OUT:

Discussions

Next up

Scroll bar is missing in Chrome on Windows 10 [FIX]

Alexandru Voiculescu By: Alexandru Voiculescu
2 minute read

Google Chrome is the most popular browser out there. It is a reliable tool to surf the Internet and has many great features. However, nothing […]

Continue Reading

What to do when your Uplay achievements are not syncing

John Taylor avatar. By: John Taylor
2 minute read

Uplay is an amazing game distribution platform created by Ubisoft. It can be used to buy and download games as well as DLCs. It can […]

Continue Reading

FIX: Ubisoft server unavailable

John Taylor avatar. By: John Taylor
2 minute read

The market is filled with game distribution platforms like Steam, Epic Games Store or GOG. As such, some gaming giants have decided to build their […]

Continue Reading