Hello All,
I had to create the table below using the valuelist:
Dimension:
=Valuelist('artist spaces','area','collect','spaces')
Expression 1: Extremely Important:
=If(Valuelist('artist spaces','area','collect','spaces')='artist spaces',Count({<[artist spaces]={'Extremely Important'}>}[artist spaces])/ Count(Total [artist spaces])....etc......
Expression 2: Important:
=If(Valuelist('artist spaces','area','collect','spaces')='artist spaces',Count({<[artist spaces]={'Important'}>}[artist spaces])/ Count(Total [artist spaces])....etc......
Now, when I look at the color, it is very awful.
Does someone has the formula to change the color?
Thank you for your help.