Forum Discussion

Odn_ndO's avatar
Odn_ndO
Icon for Helper I rankHelper I
1 year ago

Switching Determiner from Work Weeks to Days in Power BI Based on Date Input

Hi all, 

 

please help. seeking advise on the below.

 

I have set up my entire Power BI report to use work weeks as the primary determiner. However, when a specific work week is reached, I need the determiner to switch to days. The days should be determined based on the date input in the table. How can I implement this change in my Power BI report? A seperate page has been created but i am not able to get the desired results.

1 Reply

  • Use a calendar table that includes the work week column.  Add both that column and the Date column to the standard slicer. It will automatically create the hierarchy for you.