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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
AndrewPF
Helper V
Helper V

change chart x-axis based on slicer selection

I have a simple chart which shows number of detections over time:

 

AndrewPF_0-1676979099304.png

 

Currently it has around 8 months worth of data and the x-axis is month of detection. 

 

I also have a chiclet slicer which the user can click to show only detections in the last 30 days:

 

AndrewPF_1-1676979134414.png

 

Is it possible to alter the chart so that, when the slicer option is selected, the x-axis on the chart changes to day of detection ?

 

AndrewPF_2-1676979174146.png

 

instead of month of detection? 

 

At the moment, the best solution I have is to create two separate charts, and hide or unhide them based on input from buttons and bookmarks. 

 

But I want to use the slicer, not a bookmark, to make the selection. 

 

Is this possible? 

 

2 REPLIES 2
AndrewPF
Helper V
Helper V

Unless I've missed something, I don't think that's going to work.  I want to the X-axis of my chart to be either month or day, but I want the slicer to contain the Last 30 days flag.  I have other visuals in the same tile which I also want to be updated by the Last 30 days flag. 

rohit_singh
Solution Sage
Solution Sage

Hi @AndrewPF ,

You can use Field Parameters to achieve this. 

https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

 

Great video on this topic by @amitchandak here as well : https://www.youtube.com/live/gae11ITerTU?feature=share

 

Kind regards,

Rohit

 

Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos!

 

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors