Bar Chart - X-axis = "Date" Hirachy (Fiscal Year -> Fiscal Quarter)

Power BI
1

Hello,
I have created a Line Chart showing the Firm Count of Cases Vs Count of Cases for Sector (all Firms in same sector).

I use the “Date” in X-axis, eg. Fiscal Year, and drill down to Fiscal Quarter.

I found the Yearly Chart, the X-axis by Fiscal Year is sorted by default in ascending order While the quarterly line chart is sorted in descending order. I would like both yearly and quarterly to be sorted in descending. Would you please advise how to achieve this? Thank you.

2018-10-31_10-10-19_BarChartParentLevel
2018-10-31_10-10-19_BarChartParentLevel.png869×398 44.4 KB

2018-10-31_10-10-19_BarChartParentLevel_withbutton
2018-10-31_10-10-19_BarChartParentLevel_withbutton.png744×409 32.6 KB

2018-10-31_10-12-48_children%20level
2018-10-31_10-12-48_children level.png733×403 36.4 KB

2

Which sorting have you completed to the actual column from your table?

If you sort this correctly then I don’t think it should be a problem.

Check out this tutorial for what I mean.

It’s likely that you may need to create a supporting column here just for the sorting.

This example is around financial years, but it’s exactly the same idea for what you need here

https://blog.enterprisedna.co/2017/12/16/sorting-by-financial-years-in-power-bi/