The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi everyone,
I have a matrix table with a 4-level hierarchy (so four columns in the 'Rows' section): Customer name and Date.
The first column is Customer name which is sorted alphabetically ascending.
The other 3 columns I need sorted descending.
So the desired sort order would be like this:
- Customer A |
- A3 |
01-03-2024 |
01-12-2023 |
01-06-2023 |
01-10-2022 |
+ A2 |
- A1 |
01-06-2019 |
01-04-2019 |
01-03-2019 |
01-10-2018 |
+ Customer B |
+ Customer C |
How can this be achieved?
Any help would be greatly appreciated.
Thanks!
Solved! Go to Solution.
Hi @GKJARC
You need a "sort column" for every hierarchy level in your table with the needed order and sort the columns from the data view:
For a date column, you should use a date table create the column with the numeric date value and multiply it to (-1):
Result :
pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
@Ritaf1983 This works, thank you very much!
Be aware though that Number.From([Date]) doesn't always work well with datetime. For datetime I ended up using this SQL to get an inverted number from date: DATEDIFF(MINUTE, EE.ENTRYDATE, '2099-12-31T23:59:59') AS DateInvertedSorting
Hi @GKJARC
You need a "sort column" for every hierarchy level in your table with the needed order and sort the columns from the data view:
For a date column, you should use a date table create the column with the numeric date value and multiply it to (-1):
Result :
pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
User | Count |
---|---|
80 | |
78 | |
37 | |
34 | |
31 |
User | Count |
---|---|
93 | |
81 | |
60 | |
49 | |
49 |