Forum Discussion
Conditional Formatting for Entire Row in Matrix table
Hello,
I am trying to get colour on entire row.
I can colour only for specific value or column. But i need it for entire row.
Requriement:
Want to colour entire row based on number of empty cells.
Tried : This is not working for me, Unable to get Measure in HASONEVALUE.
https://community.powerbi.com/t5/Desktop/Background-color-for-a-row-table-matrix/td-p/714419
Thanks in advance.
4 Replies
Hasonevalue is needed when you select the parameter value. For the measure, you can write direct conditions.
For row you have to repeat it for each column. This means the same condition for all columns.
Color Brand = if(FIRSTNONBLANK('Item'[Brand],BLANK())="Brand 11","red","green") Color scatter = if(SUM(Sales[Net Sales])>2500 && SUM(Sales[Margin])>400,"green","red")Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on LinkedinCan't do it for each column. Sections(Column) will change based on slicer selection.
FIRSTNONBLANK() will also not work for measures.
Thanks!
For Measure, I shared the second option. Also when in a matrix you select both column and row, Then your formatting based on the measure should work.
Color scatter = if(SUM(Sales[Net Sales])>2500 && SUM(Sales[Margin])>400,"green","red")Conditional formatting of matrix has been used
Hi cv2qm ，
Turn to the post below,I guess it will help.
https://community.powerbi.com/t5/Desktop/Conditional-Formatting-for-Measures-in-Rows/td-p/159321
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
