Forum Discussion
Power BI Report - Date Hiearchy
Oh i get it, You will need to create a Date Table first and then have 1 active relationship and 3 inactive relationship. Additionally, you will need to create a measure that includes function - userelationship to the date table. The slicer while use the date column from the Date Table. If you can share the pbix file, i'll be able to help further.
Hi Kaviraj11
Thank you so much for the guidance. I have no idea on how to do that so any advice would be helpful. Thank you again for the help.
Would you able to share the pbix file with sample data? I'll be more efficient that way.
Hi Kaviraj11
I really would like to but unfortunately the excel workbook is on a corporate drive so you wont be able to access the data. My apoloigies
Hi,
Here are important links:
Create date tables in Power BI Desktop - Power BI | Microsoft Learn
Active vs inactive relationship guidance - Power BI | Microsoft Learn
If it doesn't work for you, i'll see what i can do.