Power BI
Needs VotesConditional formatting to set background color to the column values in Matrix visual.
Vamshi Krishna on 14 Nov 2018 04:00:04
Conditional formatting to set background color to the column values in Matrix visual.
- Comments (4)
- Merged Idea (1)
RE: Conditional formatting to set background color to the column values in Matrix visual.
Yep - I really need this, because the matrix is the only visual that allows grouping of rows - and in my case I have a row with summary metrics and commentary - but the commentary has several view points, against one metric. I need to be able to conditionally format the grouped rows, or (ideally in my case) place a status icon next to a row header.
RE: Conditional formatting to set background color to the column values in Matrix visual.
Trying to change background color for work hours based on CategoryDesc field. This DAX formula is not working. I have tried Color Scale, Rules and Field Values nothing is working. This should not be this difficult to change.
Color = IF('dim ProjectCategory'[CategoryDesc]="Holiday", "1", IF('dim ProjectCategory'[CategoryDesc]="Vacation","2", IF('dim ProjectCategory'[CategoryDesc]="Labor - Salary","3",IF('dim ProjectCategory'[CategoryDesc]="Labor - Hourly", "4",IF('dim ProjectCategory'[CategoryDesc]= "Labor - Daily","5","")))))
Name ProjectCategoryGroup Category CategoryDesc WorkHours
Jane Doe LABOR HOLIDAY-L Holiday 8
Jane Doe LABOR HOLIDAY-L Holiday 8
Jane Doe LABOR HOLIDAY-L Holiday 24
Jane Doe LABOR LABOR-DLY Labor - Daily 11
Jane Doe LABOR LABOR-DLY Labor - Daily 12
Jane Doe LABOR LABOR-HRLY Labor - Hourly 160
JDoe LABOR LABOR-SAL Labor - Salary 16
Jane Doe LABOR VACATION Vacation 16
RE: Conditional formatting to set background color to the column values in Matrix visual.
It would be nice in situations where you have banded rows but need to use conditional formatting to set the font color equal to the background color if a certain value shows up.