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 they user can select the month (only) to display visual information. Regardless what I tried in the slicer its putting it in a hierarchy view. I have unclicked the Auto/Date Time for new files and have unticked the Auto date/time in the current file setting. I have spent hours on trying to fix this. Can someone please assist me because I am trying to show Executive Leaders this dashboard by the end of the week., Thanks so much!
8 Replies
Hi,
Make sure you have this option selected for the attribute put in slicer.
or just have the month selected under hierarchy
Hi Kaviraj11,
I looked in the slicer dont see anything close to the pic. I pasted a screen shot below on what I am seeing. Thank you so much for the help.
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.
