Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
in this screen shot, i need 1st Q to show months as secondary layer, months should be sorted by my index which is table, only the 1st Quarter not sorted properly, rest of quarters are good. this list below has already been sorted by "label index column". any suggestion to fix this??
LabelLabel Index
1st Q | 1 |
11/1/2020 | 2 |
12/1/2020 | 3 |
1/1/2021 | 4 |
2nd Q | 5 |
2/1/2021 | 6 |
3/1/2021 | 7 |
4/1/2021 | 8 |
3rd Q | 9 |
5/1/2021 | 10 |
6/1/2021 | 11 |
7/1/2021 | 12 |
Solved! Go to Solution.
i just answered my own question, the month order is sorted automatically by calendar, because month display is from date hieracy-month in calendar table., solution is to display the year hieracy as well- although this will add more subtotal on columns, but that is another question.
i just answered my own question, the month order is sorted automatically by calendar, because month display is from date hieracy-month in calendar table., solution is to display the year hieracy as well- although this will add more subtotal on columns, but that is another question.
sort column index table has been saved corrected and refreshed to PBI report. anything else you suggest me checking?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
69 | |
57 | |
37 | |
36 |
User | Count |
---|---|
83 | |
67 | |
62 | |
46 | |
45 |