Slicers

[Tottempudi]

Hello,

Need Quick help, i have two slicers one for Quarter and second one for Weeks.

can i auto select the values on Week Slicer based on the Quarter selection slicer.

any help is much appreaciated. 

thanks,

Venkat T

[jdbuchanan71 · Accepted solution]

You can use a measure as a visual level filter on the Week slicer and set it to "is not blank".  Then, when you pick a quarter, only the weeks where the measure is not blank (meaning the fall into the quarter) will be displayed in the slicer.

[MattAllington]

Read my blog article here https://exceleratorbi.com.au/filters-on-power-bi-slicers-wait-what/