Forum Discussion
Helper Vchange chart x-axis based on slicer selection
I have a simple chart which shows number of detections over time:
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:
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 ?
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
rohit_singhSolution 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,
RohitPlease mark this answer as the solution if it resolves your issue.
Appreciate your kudos!- AndrewPF
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.
