Multiple Line and Multiple Bar Chart

[Anonymous]

Hello Power Bi Users,

I would like to know if there is any solution for my issue. As of now, we are using two separate visuals stacked on top of each other (line and bar) as shown in left visual. We would like to have this in a combined fashion to make life easy 

  I tried using line and bar combined visual from Power Bi but it provides a single aggregated line value for two categories. I would like this to split as per the category if possible. 

Link for the sample data: https://www.dropbox.com/s/mwq90yxzfkyik0d/DataForPowerBICommunity.xls?dl=0

Thank you for your help. 

[Anonymous]

HI @Anonymous ,

You can write a measure to summary these values and manually to get the average value of them to show the mix line.

Mixed Line =
CALCULATE (
    DIVIDE ( SUM ( T1[Column1] ) + SUM ( T1[Column2] ), 2 ),
    ALLSELECTED ( T1 ),
    VALUES ( T1[AmountGroup] )
)

Regards,

Xiaoxin Sheng

[Anonymous]

Hi There,

What do you mean by the Mixed Line? Is it just the average line (one) for those two categories? 

Thank you,

Vidya

[Anonymous]

Hi @Anonymous,

It means its graph is mixed with two value fields that similar to your snapshot expected.
Regards,

Xiaoxin Sheng