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.
My report looks like this... Day 1
Day 10
Day 11
Day 2
I want it to look like this........
Day 1
Day 2
Day 3 ect ....
My raw data is Day 1
Day 2
How do I get the report colum to look like the my data colum
Solved! Go to Solution.
HI @Sail136,
How did your records store? Did these stored in different fields or they are in the same field and use whitespace to define the hierarchy level? If this is a case, you can split by the delimiter and sort by different hierarchy fields on the query editor side.
Regards,
Xiaoxin Sheng
HI @Sail136,
How did your records store? Did these stored in different fields or they are in the same field and use whitespace to define the hierarchy level? If this is a case, you can split by the delimiter and sort by different hierarchy fields on the query editor side.
Regards,
Xiaoxin Sheng
you need to add a new column with the desired sort order (for example an index column). Then in Power BI you can use the "sort by another column" function.
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 |
---|---|
13 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
19 | |
3 | |
2 | |
2 | |
2 |