Forum Discussion
Solved
Dynamic Time Axis
Hi I have a table which has financial data for quarters and annually for different companies and I want to switch between the two using a slicer and for the time axis to change from displaying th...
Hi AutyDA ,
I think you can try to sort your visual by axis [Year Quarter] field.
Result is as below.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, this solution unfortunately loses the order on the x axis with items not being placed according to date.
What do you mean by "loses the order"? If you are using a dimension that is a not a date or a number, that dimension will be sorted alphabetically unless custom sorted by a different column. https://radacad.com/sort-a-column-with-a-custom-order-in-power-bi