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 ,
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 Zhou
If 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.
Rico, thank you. I knew there had to be a simple way of doing this which I was missing. Clicking the 3 dots for more options in the top right of the visualization allows you to select the form of sorting the axis as you wish. Perfect, thanks.