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 Folks,
Please help me with below issue:
If I select only one fiscal year then Quarter are showing up in correct order:
But if I select 2 Years then it is not coming in correct order.
Here I need , Q1-JAS-2019, Q2-OND2019, Q3-JFM-2020, Q4-AMJ-2020, Q1-JAS-2020,Q2-OND-2020 order.
I am using sort by column method but it fails when it comes to multiple selection in Fiscal year.
Kindly Help!
Solved! Go to Solution.
@Anonymous , You have to mark Sorting Quarter as the sort column for Quarter Year
refer for steps https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
@Anonymous , You have to mark Sorting Quarter as the sort column for Quarter Year
refer for steps https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
@amitchandak , I have done that but it's not working with slicers when I am selecting more than 1 year in year slicers.
Sort by column is working only when 1 Year is selected in Fiscal year Slicer. (I have used Sorting Quarter to Sort it)
@Anonymous , looking at Sorting Quarter, it should work fine across year.
You have selected column "Quarter Year" and then from menu click on sort by column and selected Sorting Quarter
and your visual is sorted on "Quarter Year" (option under 3 dots)
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |