Forum Discussion
Power BI Report - Date Hiearchy
Good afternoon I am hoping someone can please assist me. I have connected an Excel Workbook to a Power BI report. In the Excel workbook there are 4 date columns. I am trying to create a slicer do ...
Kaviraj11
Solution Sage
Solution SageHi,
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?