Forum Discussion
Color formatting.
Hi ,
i need row wise color formatting below like this, please help on this issue.
Regards,
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:
3 Replies
- Greg_DecklerCommunity Champion
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.
- amitchandakSuper User
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 - v-diye-msftCommunity Support
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: