Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

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
May PBI 25 Carousel

Power BI Monthly Update - May 2025

Check out the May 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.