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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Miruthan
Advocate II
Advocate II

Dynamically change X axis in Line chart

Hi Experts,

 

I have line chart(Products) which data got filter based on date range in Date Slicer. Data range slice mapped to Date dimension and date dimesion has multiple to one one relationship with product table.

 

Here In line chart comparing sales of product on period and year,  How to change X axis names based on date selected in the date range.


For ex:

Date range is 04\01\2018 - 30\06\2019

X axis Should change dymamically to March 2018 ,June 2018, September 2018 , Decmebr 2018, march 2019  and June 2019.

 

Thanks in advance.

 

 

1 REPLY 1
v-yuezhe-msft
Employee
Employee

@Miruthan,

Do you drag Date field of the Date dimension into X-Axis of the Line chart? In my scenario, X -Axis changes dynamically when I use a Timeline slicer to filter th line chart.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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