Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Bar chart - group X-axis using 2 fields

The below shows a graph in Excel showing the "SLM Status" & Priority plotted against "number of tickets"   How do we recreate this within Power BI. All we have achieved so far is to select th...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, Anonymous 

     

    As a workaround, you may try steps as below.

    Based on your description, I created data to reproduce your scenario.

    Table:

     

    You may use 'Clustered column chart', click 'Field', set 'Axis' as 'SLM Status', 'Legend' as 'Priority plotted', Value as 'number of tickets'.

     

    Result:

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hi, Anonymous 

 

As a workaround, you may try steps as below.

Based on your description, I created data to reproduce your scenario.

Table:

 

You may use 'Clustered column chart', click 'Field', set 'Axis' as 'SLM Status', 'Legend' as 'Priority plotted', Value as 'number of tickets'.

 

Result:

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.