I want to color individual rows differently based on the row header in matrix (It's not alternating rows). Is that possible in Power BI?
Also, I need to format cells based on their value. Eg: If a cell's value is -500, I would like to display it as (500) in red color, i.e., I want to show the negative values in bracket with their minus sign dropped and in red color.
Any help would be highly appreciated!
Besides Font color scales for all rows, i dont think its possible to color each indivudual row.
I think this solution also help for your second problem.
give a minus (optional neutral) and max and choose colors.
The data will change accordingly.
It's under conditional formatting -> Font color scales -> (Advanced controls)