Forum Discussion

peppster's avatar
peppster
New Member
2 years ago

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 ...
Need Help
Kaviraj11's avatar
Kaviraj11
Solution Sage
2 years ago

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.

  • peppster's avatar
    peppster
    New Member
    2 years ago

    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.

    • Kaviraj11's avatar
      Kaviraj11
      Solution Sage
      2 years ago

      Would you able to share the pbix file with sample data? I'll be more efficient that way.

      • peppster's avatar
        peppster
        New Member
        2 years ago

        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