Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
arussEvansTrans
Regular Visitor

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.

1 ACCEPTED SOLUTION
MFelix
Super User
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.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

3 REPLIES 3
bc_23
New Member

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

Anonymous
Not applicable

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

MFelix
Super User
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.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors