Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I would like to add a background color for a row. Conditional formatting only works for columns.
I would like to add a color for the whole GLOBAL row only. Please help
Solved! Go to Solution.
Hi @Anonymous ,
You can create a measure and use the new 'Conditional Formating' option where you select formatting by
'Field Value' and in this you choose the measure shown below.
You do this for every column.
COLOUR GLOBAL PROJECT ROW = IF (HASONEVALUE(Projects[Project]) ,IF( FIRSTNONBLANK('Projects'[Project] , 0) = "GLOBAL" ,"lightgreen" ,"white" ) ,BLANK() )
Maria
Hi @Anonymous ,
You can create a measure and use the new 'Conditional Formating' option where you select formatting by
'Field Value' and in this you choose the measure shown below.
You do this for every column.
COLOUR GLOBAL PROJECT ROW = IF (HASONEVALUE(Projects[Project]) ,IF( FIRSTNONBLANK('Projects'[Project] , 0) = "GLOBAL" ,"lightgreen" ,"white" ) ,BLANK() )
Maria
This is not really a solution. It is a workaround. It is overhead to copy this for every column in long run of the report.
Hi @MariaP
I was wondering if its possible to change the color for the "ROWS" using a matrix chart. I mean your code works 100% if i use a table, but if i use Matriz, does not work.
I have this:
and i want to change the color of the rows (I mean the text in the first column, A) 0-15Days.... etc.
Im using matrix chart. I need that the first row, will be total green, the second one total yellow and go on, but your code just works for values.
Do you know if there is any workaround.?
Did you find any soloutions to this?
UPDATE: I have found the answer on another thread here: https://community.powerbi.com/t5/Desktop/Apply-a-color-based-on-year-differentiate-each-year-with/m-...
Hi Maria, this really helped me too. I was wondering if it is possible to add another DAX formula in to colour a different row another colour.
for example in the example presented above, if I wanted to also colour the 'APAC' row in yellow? Is this possible at all please?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |