Forum Discussion
creating a white space table
All, I'm struggling with how best to approach this. I thought conditional formatting may help, but I think I will be very limited. Let me explain what I'd like to accomplish in a Power BI matrix ...
Hi emma313823
You want to create a new measure that will change the background colour.
Some thing like this:
Colour measure =
Switch(
true()
,SelectedValue(table[PrincipleStatus]) ="Active" && CurrYrComm = BLANK()
,"White"
,SelectedValue(table[PrincipleStatus]) ="Inactive" && CurrYrComm = BLANK()
,"Black"
,"Pink"
)
Select your Matrix, got to Cell Elements, Background colour, change the drop down to Field Value and choose your measure.
Repost, apologises if the last one broke a forum rule!
I just tried it and get this.
but...I noticed that principle is spelled wrong so i changed it to principal and entered this....
WhtSpcColor = Switch(true(),SelectedValue(Principals[Status]) ="Active" && CurrYrComm = BLANK(),"White",SelectedValue(Principals[Status]) ="Inactive" && CurrYrComm = BLANK(),"Black","Pink")but still get this...oh wait...i fixed principal status also...and now get this...
