Thursday, January 11, 2018

How to disconnect visuals (bar charts, matrix etc) from Filters/Slicers in Power BI

Today I had a requirement to make a visual (bar graph) disconnected from a filter.  I had a bar graph displaying based on billing month.  The title of the chart is Count in the last 18 months.

If you have a billing month filter, then what happens is this chart will show only 1 month instead of the last 18 months as below.

So in order to show all the 18 months, you need to disconnect this visual from the filters.  To do this, you need to follow the below steps.

Step 1 Go to Edit Interactions button from the Format menu as shown below.

Step 2 Once the Edit Interactions button is highlighted, you can see extra icons for filter and none in the visuals when you hover over the top of the visual as shown below.  By default the filter icon is highlighted.

Step 3  To disconnect the visual from the filters click on the none icon as shown below.  This will not change the behavior of the visual based on the filter selected.

By doing this even if  we change the filter value for Billing Month, the visual displays all the 18 months.

No comments:

Create a New Partition on existing multi-dimensional SSAS cube.

Below is a process that I follow every year to create a partition in existing multi-dimensional SSAS cubes that I maintain. Log in to t...