Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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. 🙂
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
94 | |
92 | |
83 | |
69 |
User | Count |
---|---|
162 | |
129 | |
126 | |
106 | |
98 |