Dynamic change in X-axis when filtered by YTD,QTD,MTD slicer

[Keerthika]

Hi,
I am having YTD,QTD and MTD as a slicer. When I select YTD, the axis must show "year" scale. When I select QTD, the axis must show "Quarter " scale and MTD in the same way. I use line chart to display my values(Revenue). Is there any solution to solve this issue?
Thanks in advance.

[Keerthika · Accepted solution]

Hi,

 I found a solution. Please refer to the below link

https://www.kasperonbi.com/dynamically-switching-axis-on-visuals-with-power-bi/

This provides clear and better solution.

Thanks. 

[Mariusz]

Hi @Keerthika 

You can use combination of Bookmaks and Buttons to switch between your slicer selections and your visual setting at the same time, please watch the video.

https://www.youtube.com/watch?v=0m-PCX1uCG4

Regards,
Mariusz

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

[Keerthika]

Hi @Mariusz 

     Thanks for the reply. When I publish it in my Power Bi Service, Bookmarks and buttons doesnt work in Dashboard. Is there any solution without using bookmarks and buttons?
Thanks. 

[Mariusz]

Hi @Keerthika 

Combination of Bookmarks and Buttons is the only way that I know of to dynamicly change the visuals axis.

sorry

Mariusz