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 all!
Can anyone help me with a tricky table? I have a raw data table representing outstanding amount at specific dates in the following manner:
Dates(a) Client(b) Amount(c)
31/12 AAA 1000
31/12 BBB 1234
31/03 AAA 900
31/03 BBB 2345
30/06 AAA 1100
30/06 BBB 3456
So the objective is to create 1 Top N table on the first specific date and compare with the second specific date (both with amounts), which I can choose by slicer.
I managed to create such report only as a chart, but create the report as a table is too difficult for me.
Solved! Go to Solution.
Hi @Anonymous ,
let me know if you'd like to get below result:
Hi @Anonymous ,
let me know if you'd like to get below result:
Hi,
You can use TOP N filteration in visual level filter for date column the add the sales amount in the "By Value" field.
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 |
---|---|
108 | |
106 | |
87 | |
75 | |
66 |
User | Count |
---|---|
125 | |
114 | |
98 | |
81 | |
73 |