Report Filtering

[Vinayak_704]

I want to my whole report to show data on latest month once data get's added. How to do in Power BI?

[Idrissshatila]

Hello @Vinayak_704 ,

Refer to this solution to make the slicer default as current month even when the dates changes.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[HiraNegi]

Hi @Vinayak_704 ,

you can create a custom column in your date dimension to flag the current month and then use it to put page level filter.

CurrentMonthFlag = IF(FORMAT(TODAY(), "MMM-yy") = DateDim[MonthYear], 1, 0)

Hope this helps !

Regards,

Hira Negi

Please don't forget to upvote and Accept as answer if the reply is helpful