Forum Discussion
Power BI Report - Date Hiearchy
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.
Hi Kaviraj11
Thanks for the info. I was able to create a date table and tried doing a relationship but I am sure I screwed it up. I have my data source table that has four dates. The dates in this table can be the same for different rows. I also have a date table that has date, month, year, and quarter. When I tried doing the relationships and when I got to the report the slicer does not seem to be working for all the months. Can you help me please?