Is it possible to create this type of visual in power bi?

[Anonymous]

 

Hi everyone,

May I ask if it's possible to create this type of chart in Power bi?

Red = Catgory A

Dark Blue = Catgory B

Light blue = total of A and B

Thanks!

Kathy

[ryan_mayu · Accepted solution]

@Anonymous 

you can create three measures

A = SUMX(FILTER('Table','Table'[category]="A"),'Table'[VALUE])

B = SUMX(FILTER('Table','Table'[category]="B"),'Table'[VALUE])

A and B = sum('Table'[VALUE])

[ryan_mayu · Accepted solution]

@Anonymous 

you can create three measures

A = SUMX(FILTER('Table','Table'[category]="A"),'Table'[VALUE])

B = SUMX(FILTER('Table','Table'[category]="B"),'Table'[VALUE])

A and B = sum('Table'[VALUE])

[Anonymous]

Hi Ryan, 

Thanks for your help! Just a quick question, for the categories in the table. I have a few sub-categories ie. a1, a2, a3, b1, b2, b3. In the Field section, I created New Group and regroup a1, a2, a3 as A, b1, b2, b3 as B. Can I use the new group in 'Table' [category] = 'A'? or does it have to be a category column in the original table?

[ryan_mayu · Accepted solution]

not sure if i understand this correctly.

maybe you can try this

A = SUMX(FILTER('Table','Table'[category] in {"a1","a2",a3"}),'Table'[VALUE])

[Anonymous]

Thank you very much Ryan for your help! 

[ryan_mayu]

you are welcome