Create a comparison Report chart of an account with rest of the other account

[Kutti]

I have a requirement of creating a comparision chart using powerBi (some thing as like shown below) . Based on the selected slicer value, it should show the chart's (first bar should have the % value of the selected data (e.g: SAP from below screen)  and next bar should contain all the other data's (e.g : Except SAP all other like BGR,DST,SWQ,GDA,KRP,SWE) 

Sample output Chart

It will be great if someone able to help me to generate these report 

Note : the above screen shot is created using mspaint 🙂 

[v-sihou-msft]

@Kutti

In this scenario, I suggest you create two measures, one apply ALLSELECTED() filter, then other use ALL() filter minus ALLSELECTED().

Selected Account Sales = CACULATE(SUM(Table[Sales]),ALLSELECTED(Table[Account]))

Other Accounts Sales = CACULATE(SUM(Table[Sales]),ALL(Table[Account]))-CACULATE(SUM(Table[Sales]),ALLSELECTED(Table[Account]))

Regards,

[Kutti]

Hi ,

Thanks for your reply . 

Newly created measures are giving th expected output . But that measure value is not poissble to add as part of the X-axis in the chart . So please let me know is there any way I can do that  (measure needs to be added as part of X-axis in the stacked chart).

Regards,

Kutti