Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi There,
I have a column in my database that contains dates, I used to be able to drop a date into axis and the date herachry would automatically appear, however I am not able to do this now. The date column is formatted as a date. What have I done? How do i get it to appear again?
Solved! Go to Solution.
@MarkCBB Do you not have an actual date table? The date hierarchy for that application is meant to come from a date table with a continuous column of dates with a relationship to your other tables' date fields.
Proud to be a Super User!
@MarkCBB if you don't see hierarchy appearing automatically you can also try option as shown in image below.
@ankitpatira I dont get that option, but I have seen it before and if I create a small test table on a blank PBI file I get the option but for somereason I dont get it with this one.
@MarkCBB It's hard to tell from your cropped screenshot but it doesn't look like you put the date column in the Axis well. If it's a column visual that last well at the bottom just above filters is for Tooltips.
Proud to be a Super User!
@KHorseman sorry about that, the screen shot was incorrect, here is a better one:
@MarkCBB Do you not have an actual date table? The date hierarchy for that application is meant to come from a date table with a continuous column of dates with a relationship to your other tables' date fields.
Proud to be a Super User!
Hello , i am also having the same problem but i don't understand the solution, there is only one taple of my data that contains date , i changet the type of data to date but still i don't have the herachery option "the other team has the same data and it appers for them)
That is exactly why, thank you. Problem solved
Hi There,
I have a column in my database that contains dates, I used to be able to drop a date into axis and the date herachry would automatically appear, however I am not able to do this now. The date column is formatted as a date. What have I done? How do i get it to appear again?
Are you talking about something like this?
May I know what is the type and content of that column and what Visual's Axis that the column is dropped to?
@Eric_Zhang I figured it out, it was because I did not have consecutive dates in the date table.
What is meant by Consecutive dates?
No gaps, like weekens?
I still face the same problem, importing straight from excel, columns formatted as date in excel, formatted as date in Power BI, still unable to see the hiearchy
@mvanwynscorrect. A date table must have a continuous series of dates with no gaps.
Proud to be a Super User!
Still the same issue, just can't get the date hiearchy to work.
I've added the dates that were missing from my range, saved, refreshed even re-imported.
It just doesn't want to create a hiearchy
should the excel be CSV or XLS?
Ok found some weird behaviour.
I've copy pasted this sheet to a new one in excel and saved as CSV.
Imported it in my project and same result, no hiearchy.
Tried a new project, imported the same CSV file and now i have a hiearchy.
Very strange
I'm having the same problem. I have a table that contain multiple data and one of the columns have dates (not all days, because the company does not work on the weekends). Last week when I put that column on a chart axis I would be able to see the date hierarchy, and today I'm not able. It is very strange because I did not change anything that would have impact on that. Strange behavior. I dont want to create a table date and use date hierarchy or something like that, I just want to be able to put a date column and drill down my chart through year/quarter/month/day.
I'm having the same problem. I have a table that contain multiple data and one of the columns have dates (not all days, because the company does not work on the weekends). Last week when I put that column on a chart axis I would be able to see the date hierarchy, and today I'm not able. It is very strange because I did not change anything that would have impact on that. Strange behavior. I dont want to create a table date and use date hierarchy or something like that, I just want to be able to put a date column and drill down my chart through year/quarter/month/day.
You do not need continuous dates or even a date in every row. It probably doesn't work due to your date being related to a date in another table. You have to remove that relationship for it to work. It makes no sense.
I didn't see this thread before I replied. Since those two threads are the same question from you so I just merged them.
Please avoid duplicated posts, thanks for your understanding. 🙂
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
87 | |
84 | |
66 | |
49 |
User | Count |
---|---|
127 | |
109 | |
93 | |
70 | |
67 |