Dynamic date filter in graph

[frankhofmans]

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

[Uzi2019 · Accepted solution]

Hi @frankhofmans 

I implemented same fo my client usinf field parameter. please follow these steps:
Step1: Go to modeling tab > select field option

step2 : 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.

[_AAndrade]

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?

[Idrissshatila]

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