My report displaying published month in slicer. Next month automatically need to change, But not changing .
Could you please help me, How to set Slicer default selected value is Current month.
Thanks in advance for your help.
Go to Solution.
Hi @Sriram_86 ,
I created two calculated columns like this.
Month = [Date].[Month]
[Date].[MonthNo] = MONTH( TODAY() ) && [Date].[Year] = YEAR( TODAY() ),
"Not current month"
And add the two calculated columns to the slicer visual.
Each time the dataset is refreshed, the current month in the dataset is marked, and the default value of the slicer is always the current month.
Best regards,Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
Hi @Sriram_86 ,
Please check if this solution works for you. (pbix file is attached)
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
@Sriram_86 , In my Date table I create a month Name like this and select current month in Slicer
Switch( True(),eomonth([Date],0) >= eomonth(Today(),-1),"Last Month" ,eomonth([Date],0) >= eomonth(Today(),0),"This Month" ,Format([Date],"MMM-YYYY"))
I also sort this on
You can default value in slicer by function
Proud to be a Super User!
@amitchandak Thanks for your response. I dont have Calender table. My Main table have Date column. Is it possible to use my Main table Date column. if not possible please let me know, How to create Calender table.
If you have any sample report, Please share.
@Sriram_86 , refer to my blog for a calendar of choice for financial years
Please refer to my .pbix.
Set the default value of the slicer to the current month. As the date column is updated, the default value of the slicer will always be the current month.
Thanks for your response. Im unable to open your Power BI report. Getting error below error.
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.