Forum Discussion

hmahmudi's avatar
hmahmudi
New Member
8 years ago
Solved

Excel like group chart using PowerBI

Hi community;

I need to create a chart like following using PowerBI. Is there any way I can create using PowerBI? 

My sample data is 

GroupMonthMaleFemale
AJan343
AFeb353
AMar24
BJan323
BFeb411
BMar532

 

and the chart that i want is like following:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

or  like following:

 

  • hmahmudi,

     

    In addition, you may use 100% Stacked column chart and select Format pane > X-Axis, turn Concatenate labels Off.

3 Replies

  • Mepoo127's avatar
    Mepoo127
    Frequent Visitor

     

    If you select the icon 'At the lowest level of data' (yellow highlighted) you can see in group and month. Hope this helps!

  • Hardik's avatar
    Hardik
    Continued Contributor

    Month and group cannot be displayed togethr for this type 

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support

    hmahmudi,

     

    In addition, you may use 100% Stacked column chart and select Format pane > X-Axis, turn Concatenate labels Off.