Multiple category in X Axis - Clustered Column Chart (help)

[Anonymous]

Hi everyone,

I'm trying to recreate the chart below in Power BI (originaly created in Excel)

https://pasteboard.co/IQTroZi.png

You can see that the X axis has two categories.

• Dates
• Open X Close (category)

The dates are at the bottom, sub-categorized by number of Open X Closed items.

It's pretty easy to create this in Excel, but Power BI seems not to be capable of doing so.

I've found other help requests in the forum for similar issues, and there is a lot of people voting for Microsoft to implement this to the software.

However, as this is not yet solved, I was wondering if anyone would have a work around.

Maybe using a Bridge Table? Not sure, can someone please give me a light?

Thank you!

[v-yuta-msft]

@Anonymous ,

You may create custom hierarchy column using column [Dates] and [Open X Close], then enable the "concatenate label" option in X-axis.

Community Support Team _ Jimmy Tao

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

[Anonymous]

Hi @v-yuta-msft  ,

It seems like the Grouping method doesn't work with more than 1 column. I tried to follow the steps in the video you attached, but the tool prevents me of mixing the "Dates" and "Open x Close" columns together.

The "concatenate label" option in X-axis was already on.
Any other ideas?