Forum Discussion
Date hierarchy x axis
Hi - I'm unable to use a hierarchy and keep the x axis as continous. This link Date example (google drive shared link, is there a preferred way to share example?) shows when using the auto-hierarchy in a chart and expand all down one level in the hierarchy, the x axis type stays as continous. But if I use my manual hierarchy, it forces it to categorical. I've changed the Quarter Text column to sort by the Quarter number column but no luck. I want it to stay continous, because if it's a big dataset, expanding down to the day level, the x axis gets a scroll bar isntead of fitting inside the chart. Thanks for any help.
Hi arussEvansTrans ,
When you are using the automatic date inteliggence it creates a temporary table that has by base the date that makes it possible to have a continuous axis. When you go to text values you cannot make it continuous because of the type of data.
3 Replies
- MFelix
Super User
Hi arussEvansTrans ,
When you are using the automatic date inteliggence it creates a temporary table that has by base the date that makes it possible to have a continuous axis. When you go to text values you cannot make it continuous because of the type of data.
Hi arussEvansTrans,
AFAIK, date fields are analytic as a hierarchy based on power bi auto date/time feature. It will generate the complete hidden calendar table with full records and different date levels.
Apply auto date/time in Power BI Desktop
For the custom hierarchy fields, it contains some text field and obviously not works the same as that calendar. (your table contains text values which not able to be recognized as general date hierarchy fields)what do the continuous and categorical type options on the x-axis format section mean?
Regards,
Xiaoxin Sheng
Hello,
Has anyone found a workaround to the 'Date hierarchy x axis' issue posted by arussEvansTrans? I'd like to use a date table in my dataset, but I prefer the default auto-hierarchy expand all down one level where the x axis type stays as continous. The ability to fit the x-axis in the chart makes for a more condensed and much more readable chart. Unfortuantely adjusting the 'continuous' and 'catageorical' type options in the x-axis doesn't help.
Thank you,
Brian
