Forum Discussion
Filtered data in graph
Hi wmtan01 ,
This is possible using a TOPN approach that you can pick up the values based on the sorting you need, or using a ranking and only consider ranking between certain value so in your case the values between the ranking 11 and 109.
However the information you give is very small, so I cannot give you the correct example to fit your model, but If you can give more details maybe I can give you a more generic formula that you can use in your several measures.
Other option is on the Query Editor to sort by the values and then remove the TOP 10 rows and the bottom 10 rows so instead of making the treatment on the database you can do it in Power BI.
Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.
Hi,
I did a little bit more of digging around and saw that what I needed was actually showing Trimmed Mean on my graphs. I saw some other post about how to make it using DAX.
Thank you for your time!