Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team ,
Need your help in achieving below requirement.
I have 2 dimentions : Unit and Accounts
Categories and its respective sub categories are populated using inline load in load script.
Each unit Can contain any number of accounts (dynamic).
Each unit needs to be colored same , but accounts present inside each Unit needs to be alternatively colored .
I am able to achieve coloring measures by using Dimensionality , but unable to populate color for unit and account values section. Coloring should also reflect based on selection of respective unit.
Kindly help.PFA sreenshot
try below
if(RowNo()=1,Yellow(),if(mod(RowNo(),2)<>0,LightGray()))
try below
if(RowNo()=1,Yellow(),if(mod(RowNo(),2)<>0,LightGray()))
Hi @vinieme12 ,
Thank You for the help ,
Your solution did worked .
Since i have 2 dimensions , 1 w.r.t Unit and 2nd w.r.t Accounts .
Directly applied background expression as yellow() in first dimension (Unit).
and in second(Account) dimension : if(mod(RowNo(),2)<>0,LightGray()))
For coloring Measure value, I have modified your expression as below , please correct in case of any suggestions.
If(Dimensionality()=1,RGB(240,221,184),
If(Dimensionality()=2,If(Mod(RowNo(), 2) <> 0, RGB(222,222,222),white()))).