Forum Discussion
How to create Slicer for Multiple Columns from Date Table
Dears,
I have a request from the user that I want to show a YEAR, QUATER, MONTH in a single Slicer. when I select year value in slicer the values will be changed for other two-column and vice versa.
| Year | Quarter | Month |
Also, I want to keep default values as current_year, Quater, Month.
Kindly suggest how to archive this?
Regards,
Hi apentyala ,
There isn't a direct and simple way to do it. You could refer to these solved cases.
https://community.powerbi.com/t5/Desktop/Set-default-value-for-slicer/m-p/756763
https://community.powerbi.com/t5/Desktop/Dynamic-slicer-default-value/m-p/638606Default value for slicer is an under review feature, you could also vote for this idea to make it coming sooner.
1 Reply
Hi apentyala ,
There isn't a direct and simple way to do it. You could refer to these solved cases.
https://community.powerbi.com/t5/Desktop/Set-default-value-for-slicer/m-p/756763
https://community.powerbi.com/t5/Desktop/Dynamic-slicer-default-value/m-p/638606Default value for slicer is an under review feature, you could also vote for this idea to make it coming sooner.