Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi guys,
I am trying to filter data of a list to only display the greatest number.
Here is what I have in my Excel data:
ratio 2019
55% |
82% |
61% |
0% |
113% |
163% |
92% |
160% |
118% |
Then in PBI, I just want the greatest value (in this case: 163%) to appear.
I was trying to use the new filter future but I only find filters like "is greater than" and not "the greatest value".
Do you guys have any idea?
Thank you for your help!!!!!!
Rémy
Solved! Go to Solution.
Hi @remychag,
I created the following measure:
Yes, there are two ways you could do this. For both visuals, you would start with a table visual. The first way is to create a table with the ratio and country then filter the visual by the top value as shown below:
The second way is to create a table with only the country field, filter on top N just like before, then change the visual to a Card visual. For some reason, the card visual does not let you filter on topN, but if you start with a table visual, it will. I think the cards look a lot nicer than the table view, so I would recommend doing this. An example of this is below.
Let me know if you have any other questions!
Hi @remychag,
I created the following measure:
Hi hwegman,
Thank you for your help, it works!!! (I'm not super familiar w/ DAX)
One more question: with each ratio goes a country, ex:
Ghana | 55% |
Niger | 82% |
Liberia | 61% |
Sierra Leone | 0% |
Togo | 113% |
Senegal | 163% |
Mali | 92% |
Guinea | 160% |
Ivory Coast | 118% |
Under the biggest ratio, I would like to display (automatically) the correpsonding country and that's not possible with "Card" visualization.
Do you have any idea on how to do it please?
Rémy
Yes, there are two ways you could do this. For both visuals, you would start with a table visual. The first way is to create a table with the ratio and country then filter the visual by the top value as shown below:
The second way is to create a table with only the country field, filter on top N just like before, then change the visual to a Card visual. For some reason, the card visual does not let you filter on topN, but if you start with a table visual, it will. I think the cards look a lot nicer than the table view, so I would recommend doing this. An example of this is below.
Let me know if you have any other questions!
It works perfectly,
Thanks a lot for your help!!!
Rémy
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |