Forum Discussion

Bhoobala_P's avatar
Bhoobala_P
Frequent Visitor
9 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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