Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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 - 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:
@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:
@sree85 , You might have to unpivot high and low to get data in this manner
https://radacad.com/pivot-and-unpivot-with-power-bi
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |