Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Keerthika
Helper I
Helper I

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

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.

1 ACCEPTED SOLUTION
Keerthika
Helper I
Helper I

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. 

View solution in original post

4 REPLIES 4
Keerthika
Helper I
Helper I

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
Community Champion
Community Champion

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.

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. 

Hi @Keerthika 

 

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

 

sorry

Mariusz

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.