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.
Hi all,
I am showing % difference in a matrix table.
How can I sort top 5 Products based on another measure, see below?
Thank you in advance.
Can anyone help with this please?
Hope this helps:
Add the measure diff to tooltips and then click on the ellipsis and select descending and diff
This video illustrates that
it doesn't work for Tables and Matrix unfortunately.
Here's an excerpt from a Microsoft document on TOPN() wherein it is stated that the result is not sorted in any order. So apparently, sorting has to be done manually : https://learn.microsoft.com/en-us/dax/topn-function-dax
I think you have to built a calculated column with a RANKX and use it to order. But you have to pay attention to the circular dependency. If i have time a try to help you in the next day.
@lucadelicio thanks, please see if you can help with this one. As i am not sure how to do this.
Can anyone help please?
Is this what you need?
@lucadelicio No my friend. Please read the instruction in the PBIX
The Accuracy % table should show SKU in this order:
Thanks.
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 | |
97 | |
80 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |