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
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

 

  • peppster's avatar
    peppster
    New Member
    2 years ago

    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?