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 day!
Can someone help me how to get the first , second until 10th highest value data in a column that will be using in Gauge visual jus like this one:
and also the maximum value is different from each other but I just get it on one column. How can I do that?
Thanks in advance.
-RanHo
Hi @RanHo ,
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.If not ,pls share a sample data for your case.
Best Regards
Lucien
@RanHo , Try measure like
Rank Discount % = RANKX(all("Item"[Category]),[Discount %],,DESC,Dense)
2nd = calculate( [Rank Discount %], filter( value("Item"[Category]), [Rank Discount %] =2 ) )
or use maxx, sumx or averagex
maxx(filter( value("Item"[Category]), [Rank Discount %] =2 ), [[Rank Discount %])
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 |
---|---|
105 | |
102 | |
79 | |
73 | |
65 |
User | Count |
---|---|
141 | |
107 | |
100 | |
82 | |
74 |