Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone !
I have a bar graphic with entity sorted by number of emails sent :
I choose to reduce the visualisation : only the first 5 entity are visible (by default) and the user has to use the scroll bar to see the next one.
My question : is it possible to add a rank number next to the name of the entity to avoid the user to count the rank for each entity.
Here is what the wanted result looks like for the 5 first entity and for entity number 5 to 9 :
Thanks a lot for your help !
Kind regards ,
Gwendaline
1. If u have rank in column we can do.
2. If u have rank in measure we can't do at run time calculation, because we can't use measure as dimension.
Suggestion.
Why not u show them Rank in Tooltip.
I don't have the rank in a column because the rank can change according to filters used.
I'm new in PowerBI. Is it possible to calculate the rank according to filters and, as you suggested, to show this rank in ToolTip ?
Thanks ,
Gwendaline
Hi @Gwendaline_p,
Have you tried the solution provided by Baskar above? You should be able to use the RANK.EQ Function (DAX) to create the measure to get the rank value and show it in ToolTip in your scenario.
Regards
Hi ,
I will try your solution and keep you update.
Thanks for your help.
Gwendaline
1. Ya we can create Rank according filter as Measure not Column.
2. once u create Rank , then use that in Tool tip. so in mouse over they get the rank number .
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |