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 Team,
I have a default table visual and I need to by dault sort by two column. Date and Amount, 1st Latest Date then if date is same again sort by Largest Amount.
For Example
Debtor / Amount / Order Date
A/10000/31.12.2022
B/1000/06.10.2022
M/5000/31.12.2022
Output Require
Debtor / Amount / Order Date
A/10000/31.12.2022
M/5000/31.12.2022
B/1000/06.10.2022
Please suggest
Solved! Go to Solution.
Hi,
In the Table visual, use th shift key to sort by multiple columns.
Simple enough
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Hi,
In the Table visual, use th shift key to sort by multiple columns.
An evident limitation is all selected columns are sorted in either asending or descending order only.
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Hi,
It should be automatic when user opening the report (default view)
So what happens when you try my solution? Does the sorting not stay as is when you open the file?
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |