Forum Discussion

ppgandhi11's avatar
ppgandhi11
Icon for Helper V rankHelper V
8 years ago

grouping question

Hi,   I am very new to PowerBI and trying to achieve below.   I have below output.   Plan  Color ABC  RED DEF  GREEN GHI  GREEN JKL   GREEN MNO RED   I want below output from the above. ...
Need Help
ppgandhi11's avatar
ppgandhi11
Icon for Helper V rankHelper V
8 years ago

 

 

This is how it looks as of now. In a separate table visualization as soon as I drop colorcode, the only color it displays is GREEN because overall result is GREEN. This is happening because the GREEN/RED for individual plan is determined based on the calculation for that plan.

 

Desired output for above is:

 

Colorcode  Count

RED                2

GREEN           7

 

Thanks.

ppgandhi11's avatar
ppgandhi11
Icon for Helper V rankHelper V
8 years ago

if the color is a calculated column then it works fine. I just tested it. My problem is: color is a measure that is being derived from the calculations.