Forum Discussion
Dynamic date filter in graph
- 2 years ago
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.
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