Forum Discussion
Filter by Top N or ___
I'm pretty sure this isn't (easily) doable but looking for confirmation or ideas.
I'm working on a peer comparison dashboard - published data from other similar entities plus my own company. I'd like to set up a filter on visuals to show my company alongside the top 5 in a given category. In other words, filter by "Top five companies by sum of operating expenses OR CompanyName = MyCompany."
Top N filter? Easy. CompanyName = MyCompany? Easy. Putting them together... not seeing an easy way to do that, so any ideas or pointers (or just confirmation that it isn't possible) are very much appreciated.
Hi,
I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file if it suits your requirement.
I hope the below can provide some ideas on how to create a solution for your datamodel.
3 Replies
- AlexisOlson
Super User
I don't think this is possible with just the filter pane options but you can do pretty much any logic with a measure filter. Here's an example from another post:
https://community.fabric.microsoft.com/t5/Desktop/Measure-value-will-filter-measure-in-visual/td-p/2782001 - Jihwan_Kim
Hi,
I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file if it suits your requirement.
I hope the below can provide some ideas on how to create a solution for your datamodel.
Thanks! That'll do the trick.
