cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Albertvw
Frequent Visitor

Filter one visualisation

I want to add a single Card which filters differently to rest of report, i.e. only show ave of score of latest months' data.

 

I created new measure which works, i.e.: M1 = Calculate(Max(CSI[Month]))

 

Then to filter for latest month CSI score: M1CSI = Calculate(Average(CSI[CSI], Filter(CSI, CSI[Month] = CSI[M1]))

 

This however still calculates base on full set of filters on the page?

 

Thank you

2 REPLIES 2
maracles
Resolver II
Resolver II

Do you want the single card visualisation to show ONLY the CS! Score for the latest month, and all other visualisations to show the CSI for all months? 

Are you doing this entirely through your measure or do you have other filters applied at either a Visual or Page level? 







Yes, the single card only should show latest month.

 

Rest of Page level has different filters applied to that. However, my single card filters according to rest of the page filters, meaning the filters applied to the other visuals on the page should not affect the card calculation.

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors