How to create Slicer for Multiple Columns from Date Table

[apentyala]

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,

[v-eachen-msft · Accepted solution]

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/638606

Default value for slicer is an under review feature, you could also vote for this idea to make it coming sooner.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7162004-default-selected-slicer-o...