Forum Discussion
Solved
Make Time slicer to appear with specific date range selected, for a published Power BI dashboard
I had created a dashboard with time slicer. My date ranges, say from 2011 to till date of 2016. I had published the dashboard into power bi. Let us assume that the date selected in the time slicer is...
Hi Bhoobala_P,
In your scenario, create a calendar table and create relationship between calendar table and your original table.
Then create a new column using the following formula in the calendar table, create a slicer using the new column and select 1 as default value in the slicer. For more deatils, please review the example in this attached PBIX file.
Column = IF('Date'[Year]=YEAR(NOW())&& 'Date'[DateKey]<=TODAY()-1,1,0)Thanks,
Lydia Zhang
BhaveshPatel
Super User
Super UserIn that case,You should only use Year Column as a slicer instead of Dates. This should give you the results of the currrent year with current dates.