How to make the axis label change according to a filter applied to a setting?

[Mickoso]

Hi all, I have a question about the x-axis for different filters. I would like when filtering by range date, in x-label is years. But when I filter by a single year the x-label be months.

Is it possible? 

Regards.

[Anonymous · Accepted solution]

Hi @Mickoso ,

I don't think that's gonna happen for a while. I can give you two workarounds:
First:
Here is my sample data:

Set a field parameter:

Put parameter into X-axis and Value into Y-axis:

The output is as below:

After switching the X-axis display, use the range date filter or single year filter to filter the content.

Second:
First create a date range slicer and a visual object with the year as the x-axis, set a bookmark to that state.

Then create a single year slicer and a visual object with the month as the x-axis, set another bookmark for that state.

Set a button for each of the two bookmarks to toggle the display by clicking the button. You can refer to this post for specific steps:
Solved: chart type change on published bookmarks - Microsoft Fabric Community

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Mickoso , I doubt you can change axis based on selection.

But you can use and and continuous axis