Forum Discussion
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 the year and quarter number (e.g. 2020 Q1) to just the year (eg 2020) but I can´t get it to work. As you can see below when I use the slicer to switch from the annual to the quarterly data the time axis shows the data as year and quarter because the date hierarchy for the axis is set to show year and quarter - this will confuse the user.
Here is a link to the sample data file and pbix SampleData.pbix
Any ideas how to get this working?
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.
8 Replies
Hi AutyDA
you can use bookmarks! (https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-bookmarks?tabs=powerbi-desktop)
If this post helps, then I would appreciate a thumbs up 👍 and mark 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.
