Forum Discussion
date no hierarchy
Complete beginner question. Using Power BI Desktop, connected to a SQL Server database with a database datetime field called ReferenceDate. On the Modelling tab, this field shows as a "Date" Date Type and the formatting is showing the date format I require. All is good.
However when I drag that field into the Axis field, it doesn't create a hierarchy. I've read that hierarchies automatically appear for date and/or time fields but it's not working for me. Am I missing something?
Sorry, by Tabular I was referring to SSAS (SQL Server Analytics Services) or basically a cube. Although a cube is not actually Tabular. In any event, the question was directed toward whether or not you were using DirectQuery. I highly suspect that is the issue. Using DirectQuery puts a fair number of limitations in place. I just tried this with a simple SQL database table and it worked just fine. I suspect that if you import the data versus use DirectQuery that it would work just fine.
11 Replies
What type of visual are you using? I just tried this on a column chart and it worked no problem. Tried this with both a Date field and a Date/Time field. Are you on the latest version of Power BI?
The current view is a stacked column chart however I have tried several different types.
I downloaded MS Power BI about Thursday last week and I found this under Options/Diagnostics : Version: 2.32.4307.641 64-bit (February 2016)
Thanks for the quick response.
MonkeyBoy - One other question, are you connecting to database or tabular with SQL Server and if tabular, are you importing or using DirectQuery (connecting).
I'm having the same issue!
I introduced another query with the name date as I wanted to create a relationship between two tables that were completely different from each other. By bridging them with a familiar set of data such as the date column, I could collect data from each of them.
The problem started as soon as I created this table. I went back to another dashboard and noticed that the 'Document Date' in one of my dashboards was was no longer working. It wouldn't let me use it's hierachy...
Any ideas?
