Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
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.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |