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 community,
I am struggeling with the following request:
I have a matrix, which shows suppliers (which might have several creditor numbers) and their maturities, as shown in the picture below:
now I want to have a ranking, that allows to shows dynamically just the top 10, 20, 5, whatever.
Is this even possible in a matrix?
The pixeled suppliers on the left can be expanded to their various creditor numbers, so that values displayed are calculated as the sum of a creditor group name. The ranking should be according to this sum, and not on the individual creditor number.
Thanks for your help
hashtag_pete
Hi @hashtag_pete ,
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.
Best Regards
Lucien
I had a similar issue a couple of months ago. I ended up NOT using a matrix, but a table, as the Ranking had to be based on only one level (like the supplier name in your situation)...
As for having a filter allowing you to display the top 5/10/X values, that would be a great addition my report too! Let's see if someone replies - now I'm invested in this post lol.
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 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |