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,
I have 3 columns of Data (Top 20 customers for 3 years). I would like to sort the table so it starts with the largest customer in the most recent year. Right now it seems like the 20 custoemrs are just presented randomly.
Thanks in advance
Michael
Solved! Go to Solution.
Currently, we can not sort your table by using two different column. To work around this issue, you could create another column.
Sample data
And then create a table bu using the DAX below.
Table = ADDCOLUMNS ( TOPN ( 20, Table1, Table1[Amount], DESC ), "rank", RANKX ( Table1, Table1[Year] * 10000 + Table1[Amount] / 10000,, DESC ) )
Regards,
Charlie Liao
Just click on the column header and it will sort automatically
Kind regards
Yes. That will work for the total column for the 3 years, but the total coulm is hidden. I would like to sort on the most recent year - not the total. Nothing happens when clicking on one of the coumns.
Currently, we can not sort your table by using two different column. To work around this issue, you could create another column.
Sample data
And then create a table bu using the DAX below.
Table = ADDCOLUMNS ( TOPN ( 20, Table1, Table1[Amount], DESC ), "rank", RANKX ( Table1, Table1[Year] * 10000 + Table1[Amount] / 10000,, DESC ) )
Regards,
Charlie Liao
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 |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |