Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

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!

Need Help

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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?