Removing filters from a report visual

[noviceBI]

Hello everyone,

In a Power BI report, I have several visuals filtered by year and month, using two slicers. However, I would like one of the visuals (a grouped histogram) to display the values ​​for all months of the year selected in the slicer, regardless of the month filter.

Is this possible? If so, how do I proceed?

Thank you in advance for your help!

[danextian]

Hi @noviceBI 

Using a related dimension table will show just the rows selected. You can instead  use a disconnected (no relationshiop) dates table and create measures: one to return the value for the selected month and another to return the values for all months in the same year as the selected month.

Total Revenue Month Selected = 
CALCULATE (
    [Total Revenue],
    TREATAS ( VALUES ( DisconnectedDate[Month and Year] ), Dates[Month and Year] )
)

Total Revenue Year Selected = 
CALCULATE (
    [Total Revenue],
    TREATAS ( VALUES ( DisconnectedDate[Year] ), Dates[Year] )
)

Please see the attached sample pbix

[dk_dk · Accepted solution]

Hi @noviceBI ,

Yes this is possible. You need to use "edit interactions" under the Format tab.

Click on Edit interactions, then select your Month slicer. You will see some icons show up above or below the other visuals. 

Making sure that the Month slicer remains selected, you need to click on the icon on the right (ø) in the icon set that is next to your histogram visual. Then you can deselect Edit interactions, and now your Month slicer should no longer affect the histogram.

You can read more about the edit interactions functionality here:
https://learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=p... 

[noviceBI]

Hi @dk_dk,

That's perfect, thank you!