Remove Filter or Do Not Inherit Filter Visual to Visual

[Anonymous]

Hi Power BI Community

I'm struggling to get the intended result when using DAX methods to remove a filter. I have 2 visualisations in a report, a matrix with some details by department filtered by year 2020.

There is also a stacked bar chart with the same details but 3 years in the X axis. I want to be able to select a department in the matrix and filter the bar chart for all three years. So far the filtered 2020 is passed to the second visual and my attmpts so far have just returned all years.

Thanks in advance for steers in the right direction 🙂
JK

[AllisonKennedy]

@Anonymous  What have you tried so far? 

If I understand correctly, you have a matrix that has a visual level filter for 2020, and you want to select one row in that matrix and see the data for that row given the past 3 years in the bar chart. Is that correct?

As @mahoneypat suggested, editing interactions will help make the bar chart filter rather than highlight, but sounds like you are still struggling with how to get exaxtly 2018, 2019 and 2020 rather than just 2020 or just all years from the data model, is that right? 

I think a DATESBETWEEN might help you in this situation if you add that to a CALCULATE MEASURE and use that for the values in the bar chart. 

Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved. 

If you found this post helpful, please give Kudos.

I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query. 

https://sites.google.com/site/allisonkennedycv

[Anonymous]

Yes @AllisonKennedy  that is a good summation. 

DATESBETWEEN is a bit tricky in my context as our date table is a custom table, start and end dates can be different in each year. The year used is a column assigned to each cycle.

Thanks

[AllisonKennedy]

It won't be as dynamic, but could you use 

CALCULATE( expression, ALLSELECTED(something...), YEAR=2020 || Year = 2019 || Year = 2018)

Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved. 

If you found this post helpful, please give Kudos.

I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query. 

https://sites.google.com/site/allisonkennedycv

[mahoneypat]

Sounds like you want to edit the interactions between your visuals.  There is an easy way to do that.  Please see this link.

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

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat