Color formatting.

[Anonymous]

Hi ,

i need row wise color formatting below like this, please help on this issue.

Regards,

[v-diye-msft · Accepted solution]

Hi @Anonymous 

For row formatting, it's not supported currently. you might vote up for the idea:

https://ideas.powerbi.com/ideas/idea/?ideaid=229a6a2b-f26c-4afd-b1af-8cf3cbc9810f

For conditional formmating for the specific cell/column, you can check this option:

[amitchandak]

@Anonymous , No row formatting available. You need to conditional formatting on all columns.

You can create a measure like given below and use that with Field option in conditional formatting

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"
)

refer

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

[Greg_Deckler]

@Anonymous - Not sure of the rules, but looks like you want to use conditional formatting, background color. You can set it up for ranges or specific rules.