Forum Discussion
emma313823
Helper V
Helper Vcreating 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 ...
emma313823Helper V
Helper VI 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...
emma313823Helper V
Helper Voh wait...i fixed principal status also...and now get this...