Only Show data that are part of the filter

[BigKev]

Hi all,

Is there any way I could hide the Measure that is not part of the filter data?

Below what I mean.

Default view

When I clicked on Value by group 1 (light blue box)

As you can see, the Value by category bar chart also shows category B & C, which has 0 Value because they are not part of Group 1. Is there any way I could show the only Measure that is part of the filter data? In this case, only ‘A’ will appear in the bar chart.

This is a default filter function in Tableau, but it looks like not in Power BI.

Does anyone come across any workaround on what I want to achieve?

Cheers,
Kev

[v-alq-msft · Accepted solution]

Hi, @BigKev 

Based on your description, you may click 'File'=>'Options and settings'=>'Options', set as below.

Then you need to restart Power BI desktop to apply the feature.

 

You may also use Edit interaction  to achieve the same result.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@BigKev , You have the option of cross highlight and Cross filter. You can  change those from Edit interactions

https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions

[lbendlin]

I think you want to explore the difference between cross-highlighting and cross-filtering.