Hello I am having issues sorting my data from different quarters in a chronological order.
For example I want to sort data from Q3-2018 to Q1-2019. So the data should line up Q3-18, Q4-18, Q1-19, but it is not (see picture). It is also consolidating Q4 data from both 2018 and 2019 into the same Q4 column.
Also, I have verified that the data is being recognized as Date/Time in the table.
Any help on this? Thanks
hi, @Anonymous
Please refer to this screenshot:
You have to keep Year hierarchy in the visual too, otherwise, it will be aggregated in quarter hierarchy.
"however, drill down does not fix my problem.", Do not use drill down, you should use expand.
and here is a simple sample pbix file, please try it.
Best Regards,
Lin
Helpful resources
Microsoft Fabric Learn Together
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Power BI Monthly Update - April 2024
Check out the April 2024 Power BI update to learn about new features.
Fabric Community Update - April 2024
Find out what's new and trending in the Fabric Community.
