Forum Discussion
Showing multiple dimensions on a bar graph
Hi, I want to show 2 dimensions across 1 measure in a bar graph which looks like this in tableau :
Is this possible in powerbi.
Sample data set :
| Machine Name | Month | Machines Total |
| 226 | 1 | 12 |
| 226 | 2 | 13 |
| 226 | 3 | 14 |
| 227 | 1 | 15 |
| 227 | 2 | 13 |
| 227 | 3 | 16 |
| 228 | 1 | 14 |
| 228 | 2 | 18 |
| 228 | 3 | 17 |
Anonymous
Yes you should be able to do this...
Create a Clustered Column Chart
Drag Machine Name to the Axis
Drag Month to The Axis and place below Machine Name
Drag Machine Total to Value
Click Expand At The Lowest Level of Data (All down one level) in the top right corner in the visual header
Click the ellipsis... (top right corner) - Sort By - Machine Name Month
Click the ellipsis... again - Sort Ascending
Go to the Format (Paint Brush) options for the visual - X-axis - Concatenate Labels - Turn Off
That should do it! :smileyhappy:
2 Replies
SeanCommunity Champion
Anonymous
Yes you should be able to do this...
Create a Clustered Column Chart
Drag Machine Name to the Axis
Drag Month to The Axis and place below Machine Name
Drag Machine Total to Value
Click Expand At The Lowest Level of Data (All down one level) in the top right corner in the visual header
Click the ellipsis... (top right corner) - Sort By - Machine Name Month
Click the ellipsis... again - Sort Ascending
Go to the Format (Paint Brush) options for the visual - X-axis - Concatenate Labels - Turn Off
That should do it! :smileyhappy: