Forum Discussion

Bhavya's avatar
Bhavya
Regular Visitor
9 years ago

Different grouping for Line and Column values in PowerBI Line and column Combo chart

Hi,

 

I'm using Line and stacked column chart. It is supposed to look something like this:

I need to group the line values based on UserType( ExternalUser,FoundryUserFoundry etc) and group the column values based on Geo ( US, APC,Europe etc)

 

Currently I'm able to group the column values based on Geo and line value gives the aggregate based on Geo, I'm unable to add a seperate grouping for Line values.

My chart looks like this:

 Is there any way to add a seperate grouping for line values?

 

Thanks in advance,

Bhavya

 

Need Help

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    9 years ago

    Not sure if this meets your needs but I was able to create a group for the shared axis to group my column values one way but then also create a group for my line values.

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    Hi Bhavya,

    Please create two measure used to calculate the aggregate for different groups(Geo and Users). Then add the measures to line values. If this solution doesn't resolve your issue, please post the sample data or .pbix file for further analysis. 

    Best Regards,
    Angelia