Forum Discussion
Background colour formatting.
Hi All I have a dashboard where I need the background of a cell to reflect a certain colour depending on the contents of it. The rules are as follows. It works well mostly. But there are some...
sthandiwe , need to check data for that. Can you share sample data and sample output in a table format? Or a sample pbix after removing sensitive data.
Can you create a color measure directly on values like in the given example and use that with the "Field Value" option(in place od rule
color =
switch ( true(),
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity1" && sum('Table'[Value]) >500,"lightgreen",
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity2" && sum('Table'[Value]) >1000,"lightgreen",
// Add more conditions
"red"
)
Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.