Dense Stacked Column & Line Chart based On Date Hierarchy.. but including Hour

[zudar]

Hi all,

I'm having an issue with this Column/Line chart that I need to be dense and not requiring to scroll horizontally. Using a Date Hierarchy on the shared axis works beautifully, but the twist is that I need it to be an hourly chart instead of a daily one. When I add the hour below the Date and drill down, the graph loses its 'dense' look (see screenshots below).

Anyone who knows how to fix this? Or should I look for custom visualizations to make this happen? Could you recommend one?

Daily

Drilled down to the hour

Thank you! 🙂 

[amitchandak]

@zudar , do want you drill down or drill expanding ?

https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill

[zudar]

Thanks for the response.

I actually don't want to drill at all. Or better put: I don't want my end-users having to drill down and up. I really need to have an hourly column, it's a strict requirement for this graph. But I need to have a lot more columns to be seen at one glance than what I'm getting right now.. (the second screenshot I posted).

[v-zhenbw-msft · Accepted solution]

Hi @zudar ,

Sorry for that if you drill down, the X-axis type cannot configure to continuous, it will show the detail.

So maybe you can combine the Date column and Hour column to one column, and use the new column to be the X-axis.

Date_Hours = 'table'[Date] + TIME('table'[Hours],00,00)

If you have any question, please kindly ask here and we will try to resolve it.

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

BTW, pbix as attached.

[zudar]

Hi, It really was that simple! Thank you!