Clustered column chart in Power BI like in Excel

[sree85]

Can anyone please guide me on how to create a similar clustered column chart from data as shown below in Power BI? Looks like fairly straightforward in Excel but not so in Power BI.

Thanks.

[amitchandak · Accepted solution]

@sree85 , You might have to unpivot high and low to get data in this manner

https://radacad.com/pivot-and-unpivot-with-power-bi

[sree85]

Hi @Tahreem24 and @amitchandak ,

Thank you so much for the answers. Will be doing so.

[Tahreem24 · Accepted solution]

@sree85  - I guess you need to unpivot the data to get the expected result.

Step 1: GO to Transform query editor

Step 2: Select High and Low Column and under Transform Menu click on Unpivot Columns.

Step 3: Then Save and close the editor.

Step 4: Take Clustered column chart from visualization pane and put Attribute Column on Axis, Category column on Lengend, and Value column on Values option.

so, you'll get something like below:

[amitchandak · Accepted solution]

@sree85 , You might have to unpivot high and low to get data in this manner

https://radacad.com/pivot-and-unpivot-with-power-bi