Forum Discussion
Dynamic date filter in graph
hi all,
i have a dashboard with a lot of bar graphs with the date (from a date table with day, week, month, quarter, year) on the X-axis and value on the Y-axis. You can switch from year to quarter to month with the arrow up and arrow down symbol on each bar graph, but then the user has to switch it in every bar graph. Is there way to create a measure based on a filter, where the user can select fe Year, Quarter, Month or Week, and that the x-axis of all graphs on that page switch to this selected value?
Thanks in advance,
Regards, Frank
Hi frankhofmans
I implemented same fo my client usinf field parameter. please follow these steps:
Step1: Go to modeling tab > select field optionstep2 : give Parameter name to X Axis > Drag and drop year, month qtr, date from right side to the left side.
Click create.
Step3: New slicer is added on page.steps4: take your X axis value in Line chart X Axis.
step5: change slicer format to tiles. and if dont want any hierarchy change it to single select.I hope this would work for you.
3 Replies
Hello frankhofmans ,
you can create a 2 field parameters one for x-axis and one for y-axis and apply their values on all the visuals, thus when a field is selected then it will apply to all.
check how to do field parameters
https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
Hi,
You can create a field parameter and use it on the x-axis and on a slicer and it will work like you want.
Take a look at this linkedin post:https://www.linkedin.com/feed/update/urn:li:activity:7053624375098433538/
Is something like this that you're looking for?Hi frankhofmans
I implemented same fo my client usinf field parameter. please follow these steps:
Step1: Go to modeling tab > select field optionstep2 : give Parameter name to X Axis > Drag and drop year, month qtr, date from right side to the left side.
Click create.
Step3: New slicer is added on page.steps4: take your X axis value in Line chart X Axis.
step5: change slicer format to tiles. and if dont want any hierarchy change it to single select.I hope this would work for you.
