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.
Good morning all,
I have a measure that is a ratio between the sum of two columns and with this measure I want to give the top 5 and bottom 5 values. I have no problems with the TOP 5, although, I have several examples that this ratio is 0, so when I want to get the 5 bottom values, power bi gives all the zero values. I've applied another filter in order not to show the zeros, however I have to change my bottom 5 to bottom N, in order to get the lowest 5 values that I want to be represented.
Is there any possibility get the bottom 5 values that are bigger than 0 and not have to fix mannually the BottomN?
Thank you so much for your help
Best regards
Solved! Go to Solution.
Apply another filter on the measure and select advanced filtering. Select "is not" and input '0'
Apply another filter on the measure and select advanced filtering. Select "is not" and input '0'
Perfect! Thank you so much
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 |
---|---|
107 | |
93 | |
77 | |
64 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |