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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
aarola
Frequent Visitor

Continuous hierarchy axis

Hi,

 

I am trying to do a line chart from 15min data. The problem comes when I want to see accumulated hourly values. That's fine to be done with hierarchy axis (custom levels = weekday, hour), but the axis is never continuous, it's always categorical when drilling down with hierarchy. This means that a scroll bar will apear and will never autoscale...

 

I have seen a similar problem in another post as well, no answer yet:

 

https://community.powerbi.com/t5/Desktop/How-to-create-a-Continuous-custom-Date-Hierarchy/m-p/380691

 

Is there any way to have a continuous hierarchy axis?

3 REPLIES 3
v-xjiin-msft
Solution Sage
Solution Sage

Hi @aarola,

 

With current information, it is hard for us to understand your requirement. Could you please share us your pbix file with One Drive or Google Drive if possible?

 

If you can't, please share us some sample data which we can copy and paste directly and its corresponding expected result. So that we can get a right direction and provide more proper suggestions.

 

Thanks,
Xi Jin.

Hi,

 

Of course. I'm sorry I didn't explain properly all the problem. I attach some pictures, I will prepare some example file as well.

 

This is how the chart looks like if I use the inline hierarchy (directly from a single date format column):

 

image.png

 

This is so good, as the axis is "continuous" type and then the axis does not need to show all the values in the axis.

 

However, I have hourly data (and even 15 min frequency data), not only daily. Inline hierarchy cannot drill lower than daily frequency, so that's not enough.

 

The alternative is to build a custom hierarchy, with different columns: year, month, day, hour, minute.

 

I have built those columns in the same main table.

 

This is how it looks with this custom hierarchy, drilling down to "day":

 

image.png

As you see, the axis now is trying to show all the values in the table. This happens because this is a "categorical" type axis. 

 

Axis type appears as "categorical" when custom hierarchy is used, and it cannot be changed to continuous.

 

Many thanks

 

 

Hi @aarola,

 

=> The alternative is to build a custom hierarchy, with different columns: year, month, day, hour, minute.

 

So you have defined a custom hierarchy. Then how did you define the hour and minute?

 

With only screenshots, it help little to troubleshoot you issue. If it is possible, please share us your pbix file.

 

And I have found a relevant thread which is Hourly Level date hierarchy. Please make a reference, see if it helps.

https://community.powerbi.com/t5/Desktop/Date-Hierarchy-at-Hourly-Level/td-p/210538 

 

Thanks,
Xi Jin.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors