Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to use the same bar graph to show either top 10 or bottom 10. Not quite sure how to pull it al together using the same graph and samme measure, i.e the user should be able to switch between the views with a filter, either selectiing bottom 10 or top 10.
help please this is utterly frustrating
Proud to be a Super User!
Solved! Go to Solution.
One Way could be this:
Step 1: A Table With Top 10 and Bottom 10 Text. To use in slicer.
Step 2: Create a measure to Rank:
Rank = IF ( HASONEVALUE ( View[View] ), SWITCH ( VALUES ( View[View] ), "Top 10", RANKX ( ALL ( Table1 ), CALCULATE ( SUM ( Table1[Points] ) ),, DESC; DENSE ), RANKX ( ALL ( Table1 ), CALCULATE ( SUM ( Table1[Points] ) ),, ASC; DENSE ) ) )
Step 3: Use A chart and Apply a Visual Level Filter Rank less or equal to 10.
One Way could be this:
Step 1: A Table With Top 10 and Bottom 10 Text. To use in slicer.
Step 2: Create a measure to Rank:
Rank = IF ( HASONEVALUE ( View[View] ), SWITCH ( VALUES ( View[View] ), "Top 10", RANKX ( ALL ( Table1 ), CALCULATE ( SUM ( Table1[Points] ) ),, DESC; DENSE ), RANKX ( ALL ( Table1 ), CALCULATE ( SUM ( Table1[Points] ) ),, ASC; DENSE ) ) )
Step 3: Use A chart and Apply a Visual Level Filter Rank less or equal to 10.
What is the view/(view) and Table 1 points in the rank formula?
Hi Vvelarde,
I have been trying to solve a similar issue, and have been spending much of the day trying to resolve this.
Would you be kind enough to send me a attachment of your Power BI? I have tried using your DAX, but alas, I am not getting the results I am expecting. 😞
Your results look to be what I would like! I appreciate the help!
All my best,
Jolsby
@jolsby what is the problem you are having?
Proud to be a Super User!
Hi @vanessafvg,
Thanks for your reply. For context, I am continuing from this article, which allows me to have dynamic meaures.
When I try to leverage the "Measure Selection" as referenced in the above article, for a Top 5 or Bottom 5, I have yet to get the logic exactly as I would like. If you would like to follow along, you can use the article for reference to my current state.
Thus this is the outcome that I am recieving.
Best,
Jolsby
@jolsby nothing obvious sticks out to be honest. are you absolutely sure the measure you selecting has a bottom ranking? ie i can't see the measure, have you got the right one in there.
The first thing i would say is remove everything and get to basics.
1. Create a bar graph and drag your measure on to it without the dynamic filtering. if everything looks fine ,
2. create 2 new individual ranking measures one for top and one for bottom and add them one at a time to the visual filters to check if the work. if that works..
3. then add the top and bottom filters and the original rank measure back and see if that works
4. then add the dynamic filters
basically break it down until you can isolate where the issue is
Proud to be a Super User!
Hi Vanessa,
Thanks for the help!
I was able to figure it out here!
https://community.powerbi.com/t5/Data-Stories-Gallery/Executive-Insights-by-Decisive-Data/m-p/181742
Best,
Jake
brilliant job thanks!
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |