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 ema
If I have understood what you are asking we need to create a new measure:
Colour measure =
Switch(true(),
SelectedValue(Principals[status] ) = "Active" && CurrYrComm <> BLANK()
,"White" --Or use "#FFFFFF00" for clear
,SelectedValue(Principals[status] ) = "Active" && CurrYrComm = BLANK()
,"Black"
,"Pink"
)
Then assign this under Cell Elements choose Background color and click the Fx symbol.
Change the dropdown in the top left to Field value and select your measure.
If this has worked please mark as a solution for others to find 🙂
Let me know if it doesn't!