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.
I have created a dynamic top N grouping following below YouTube (Top 10, Next 10 and The Rest).
Everything go fine as shown in Top Customer Analysis.
However, as the model would like to let user choose currency, and when I add the cur to the table, the grouping is not correct (as Top Customer Analysis with currency).
Even though I would like to add the ranking to the table, I got the same issue.
Can anyone help for this?
https://www.youtube.com/watch?v=0HR_h6YTjzc
File: https://drive.google.com/file/d/1XE-M3uGtv2EgDPc4V2rJ9QyEqHikqOQ9/view?usp=sharing
Hi @Anonymous ,
After test with your sample file, I found 'local currency' category contains multiple currency types.
Obviously, it will face the issue of ranking sales between different currencies. (you can't direct do ranking on the different type of currency records)
I 'd like to suggest you convert these records to default currency type, then you can ranking and extract top n records based on the converted currency and add currency fields to display the original currency type of these records.
Regards,
Xiaoxin Sheng
Thanks for your advice
Unfortunately, the currency is a must (althoght i agree it is not a good idea)
After research, I am afraid it is impossble for Power BI to handle it.
I may seeking seeking for another presentation and just show top 10 customers and 11-20 customers
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |