Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 ...
  • Sean's avatar
    Sean
    7 years ago

    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:

     

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
7 years ago

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:

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    This worked after some tweaking. Thanks