Forum Discussion
Dynamic Time Axis
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 AutyDA
You can use field parameters to switch between dimensions. Please take note that it allows one dimension at a time only. Please see this post:
Hi, this solution unfortunately loses the order on the x axis with items not being placed according to date.
Hi AutyDA ,
I think your data model doesn't support Field Parameter function. There is a column [Quarter or Year] to determine whether quarters or years.
I suggest you to use the [Year] and [Quarter] column from sheet1 in your visual, when you select Year, Quarter will show blank.
Or you can try Bookmark navigator.
You can download my sample to learn more details.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Rico,
Using the [Year] and [Quarter] column from sheet1 in the visual works exactly as you say. In your pbix file the visual shows the years and quarters in the right order (year Q 1, 2, 3 then 4). When I try to put this in to my work it does not do so, the chart orders the axis according to the largest revenue number. Also in your file if I remove the [Year] and [Quarter] column from the axis and then put them back it also loses the order and lists everything by largest revenue. Am I missing something really simple to get this working or is this something related to the bookmark?
This shows an example of what I get:
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.
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