Showing results for 
Search instead for 
Did you mean: 
PicPay_Sam Frequent Visitor
Frequent Visitor

PBI Online doesn't create date hierarchy



I am importing an Excel file into PBI Online using Get Data > Files > Local File > Import.


After the dataset is created, dragging a Date+Time column to the Axis field on a chart doesn't give me a hierarchy, and the option doesn't appear when right-clicking either.

Instead, additional columns for Year, Month and Date are created when I import, but stacking those on the axis doesn't yield the same results as having a properly created hierarchy.


How can I get a hierarchy in this case?

Super User
Super User

Re: PBI Online doesn't create date hierarchy

@PicPay_Sam Start in the Desktop, publish to the Service. All the modeling and "auto generated things related to that model" is built in the Desktop. The Service doesn't have the capability to do those things, it's primary function is for sharing, or supporting embedding/live streaming.

Near SE WI? Join our PUG Milwaukee Brew City PUG

Helpful resources


How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 40 members 961 guests
Please welcome our newest community members: