How to set default quarter value in Power BI Slicer for selected charts in power BI report?

[hrishi555]

Hi,

I am looking for a solution where I can use default filter of quarter (example- Q3-22) for only for selected charts in the Power BI report by keeping the existing functionality of slicer (meaning if someone want to see the data for Q4-22 then they can select that dropdown slicer value and related data will show on those charts).  Is it possible? if yes, then how?

Thanks in advance!

[v-xiaosun-msft]

Hi @hrishi555 ,

You can try as what @amitchandak  suggested.

And if your problem has been solved, please mark the answer you need as a solution to help the other members find it more quickly. If not, please tell us in order to help you futher.

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ThomasWeppler]

Great tip @amitchandak 
I think I will start to use it myself.

[amitchandak · Accepted solution]

@hrishi555 , You have to create a new column like below and save of current qtr

Switch( True() ,

format(today(), "\QQ-YY") = format([Date], "\QQ-YY"), "This Qtr",

[Qtr Year]

)

Switch( True() ,

format(today(), "\QQ-YY") = [Qtr Year]), "This Qtr",

[Qtr Year]

)