Forum Discussion

bdehning's avatar
bdehning
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

Clustered Column with Year Month Labels

How would one go about creating something this in Power BI?

 

 

  • Hi bdehning ,

     

    Tested with the native bar chart in Power BI. Unfortunately, there is no such option to not concatenate the year and month labels which is possible with a column chart.

    This is the closest I could get to

     

    Here's how I achieved the above:

    Make sure you have a separate column for Years and Months and add them to Y-Axis

    Add your values to X-Axis.

    Click the Expand all down one level in hierarchy icon

     

     

     

4 Replies

  • Hi bdehning ,

     

    Tested with the native bar chart in Power BI. Unfortunately, there is no such option to not concatenate the year and month labels which is possible with a column chart.

    This is the closest I could get to

     

    Here's how I achieved the above:

    Make sure you have a separate column for Years and Months and add them to Y-Axis

    Add your values to X-Axis.

    Click the Expand all down one level in hierarchy icon

     

     

     

  • Yes that worked as best it could. 

     

    Now how to I make the chart continous to eliminate scroll bars?