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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Ranju
Regular Visitor

Dynamic chart X values based on slicer.

Hi Team,

I am very new to the Power BI work. Here we have a new requiremnt from client side.

The X values of chart should be change based on the below slicer date . That is when ever day selected then the X axis should be display as 1 ,2 ,3  to 31  and same for 4 weeks or one month. If the months selected 2 to 6 months then the x axis should display as weeks and above 6 months in slicer then the x axis should be months. 

  • Day – Show Days
  • Week – Show Days
  • Month – Show Days
  • 2-6 Months – Show Weeks
  • 6 + Months – Show MonthsPlease let me know if you have did same kind of implementation.

Ranju.

2 ACCEPTED SOLUTIONS
v-shex-msft
Community Support
Community Support

Hi @Ranju ,

 

You can refer to following blog to know how to create a dynamic attribute slicer to achieve your requirement:
Dynamic Attributes In A Power BI Report

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

Thank you . It is working now .

View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
Community Support

Hi @Ranju ,

 

You can refer to following blog to know how to create a dynamic attribute slicer to achieve your requirement:
Dynamic Attributes In A Power BI Report

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Thank you . It is working now .

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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