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.
Hello
Very new user here with a question. I am trying to get a constant 1-25 ranking down the left hand side of this data table. That way, if I sort by either Volume or Plant Margin by Volume, the numbers 1-25 will still be in descending order down the left hand side and the accounts will change (based on Volume or Plant Margin by Volume). Can anyone assist? This is the DAX I have come up with so far
Rank = RANKX('Customer',[$/volume 2017],,DESC)
Solved! Go to Solution.
Hi @zflory,
For your scenario, you can add a rank column to calculate the rank, then drag this to visual level filter, switch to advanced mode with 'is less than or equal to' and input 25 as filter range.
BTW, calculated column not works with slicer and filter, if you want to achieve the dynamic rank or effect with other filters, you need to use measure to instead.
Regards,
Xiaoxin Sheng
The below data table is what I'm working with. I would like to have numbers 1-25 in descending order down the left side of the matrix. That way, when I sort by either Volume or Plant Margin by Volume, the numbers will stay in constant order (1-25) and I will be able to determine the top 25 customers (in order) or either of those metrics (Volume or Plant Margin by Volume). I apologize, I should have included the matrix in my original post
Also, when doing my RANKX measure, is it only possible to use calculated columns in the expression argument of the measure? I am wanting to add volume from my orignnal data sheet in that argument, but Power BI is only letting me include calculated columns
Hi @zflory,
For your scenario, you can add a rank column to calculate the rank, then drag this to visual level filter, switch to advanced mode with 'is less than or equal to' and input 25 as filter range.
BTW, calculated column not works with slicer and filter, if you want to achieve the dynamic rank or effect with other filters, you need to use measure to instead.
Regards,
Xiaoxin Sheng
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |