Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
hello everybody
i am trying to get the ranking for countries which one The most affected country by corona
so i did the measure correctly https://powerbi.tips/2017/07/ranking-values-with-measures/
it is working in the tables but then i made it like a card in tooltip page so when i tried in the map it was not filtering correctly
and here when i put it like a card in tooltip
is there any solution ?
Solved! Go to Solution.
You need to use field from "Location" in the rank formula.
use a tooltip page, it likes that you use drillthrough from that map visual to tooltip page, then it will filter that country in tooltip page.
so it will show only one country data in tooltip page.
Therefore, you could only all instead allselected function, but if you use slicer filter data in report, it will be covered by tooltip, so it will always rerturn 1 when you use allselected.
Regards,
Lin
Just replace ALL instead of ALLSELECTED in the rank measure.
Since when you use a tooltip page and it likes you use a slicer to filter the data, so it will always return 1.
Regards,
Lin
first i appreciate your help @v-lili6-msft @amitchandak
so i replaced ALL instead of ALLSELECTED in the rank measure like that
here i created a map with Country Column from the Case Time Table so
ranked function worked well but the others with yellow highlight disabled not working any more and this Expected to happen
so what i have to do now?
You need to use field from "Location" in the rank formula.
use a tooltip page, it likes that you use drillthrough from that map visual to tooltip page, then it will filter that country in tooltip page.
so it will show only one country data in tooltip page.
Therefore, you could only all instead allselected function, but if you use slicer filter data in report, it will be covered by tooltip, so it will always rerturn 1 when you use allselected.
Regards,
Lin
First of all thanks million for helping me really i learned many things
second thing i made many experiments and you right about ALL and ALLSELECTED
SO FINALLY i discovered the main problem with rank with map
if i made the map field take a data from Country column in Location Table then the measure it will work fine but if i made the map take the data from Lat and Long cordinate Columns then the Rank Measure it will not work
so any solution
Is data displayed at the same granularity as the bar chart?
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |