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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Barrettone
Helper I
Helper I

Dynamic Filters

I'd like to apply a filter to a visual where it only shows, for example, the top 25% of the data field in Legend. 

 

So a simple example would be a Waste Kg vs Time chart, where the Legend is Reason for Waste. 

We have a huge number of waste reasons, however only a small % make up 80% of the total waste. 

 

Is it possible to apply this kind of filter? Or is there another way of doing it?

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Barrettone , check if this approach can help

Power BI Window: Pareto Analysis Again, 80% of sales, are Order by Measure when REL position is used: https://youtu.be/GpoITi_tRIw

 

Power BI- TOPN with Others- https://youtu.be/I_TY4hVlzAE
https://medium.com/microsoft-power-bi/power-bi-topn-others-8b094203a306

 

 

View solution in original post

2 REPLIES 2
Barrettone
Helper I
Helper I

Thank you, I will check those out. 

What would be great is if some of the tutorials could be for anything other than Sales, e.g. manufacturing. 

amitchandak
Super User
Super User

@Barrettone , check if this approach can help

Power BI Window: Pareto Analysis Again, 80% of sales, are Order by Measure when REL position is used: https://youtu.be/GpoITi_tRIw

 

Power BI- TOPN with Others- https://youtu.be/I_TY4hVlzAE
https://medium.com/microsoft-power-bi/power-bi-topn-others-8b094203a306

 

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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