Date Hierarchy - Column chart - Hierarchy not appearing anymore

[MarkCBB]

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?

[ankitpatira]

@MarkCBB if you don't see hierarchy appearing automatically you can also try option as shown in image below.

[MarkCBB]

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

[KHorseman]

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

[MarkCBB]

@KHorseman sorry about that, the screen shot was incorrect, here is a better one:

[KHorseman · Accepted 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.

[Am25]

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) 

 

[MarkCBB]

That is exactly why, thank you. Problem solved

[MarkCBB]

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?

[Eric_Zhang]

@MarkCBB

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?

[MarkCBB]

@Eric_Zhang I figured it out, it was because I did not have consecutive dates in the date table. 

[mvanwyns]

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

[KHorseman]

@mvanwynscorrect. A date table must have a continuous series of dates with no gaps.

[mvanwyns]

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?

[mvanwyns]

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

[Anonymous]

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.

[Anonymous]

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.

[jeffmjohnson330]

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.

[Eric_Zhang]

@MarkCBB

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