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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Jigar1276
Helper I
Helper I

Change x axis from month-year to dates based on selection of date slicer

Hi,

 

I have a bar graph and date slicer as follow:

Jigar1276_0-1635317027663.png

 

I also have calander table from which Slicer field is coming and relationship is set between "Calls" table and calander table:

Jigar1276_2-1635317144652.png

 

I want to change the x axis of my bar graph based on selection in slicer as follow:

Jigar1276_3-1635317427987.png

if selection is "Years" or "Years (Calender) then x axis should have month-year as lable.

if selection is any other ("Days", "Weeks", "Months" etc.) then x axis should have date as lable. 

 

How can I achive this with just one graph and one slicer?

 

Thanks in advance.

1 REPLY 1
amitchandak
Super User
Super User

@Jigar1276 , change of axis is possible using bookmarks. Which I doubt can fit in this case.

 

Also unpivot column, might not help help

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.