Function Background color

[clem312]

Hi,

I want to make a function for the background color of cells in a matrix.

Data are like this

I am trying to put the background color of Q73_lib cells with Q72_correspondance.Q72_lib_color
With conditional Formatting what I have tried so far didn't worked :

Q73_Background Color =

IF (MIN(Q73[Q72_correspondance.Q72_id_color])=1,"#ff99cc",

IF (MIN(Q73[Q72_correspondance.Q72_id_color])=4,"#ccccff",

IF (MIN(Q73[Q72_correspondance.Q72_id_color])=5,"#ffcc99")

etc.

))

[clem312 · Accepted solution]

Hi @amitchandak 

Thank you for your answer.

It's hard to put it in the matrix.

In line, I have a series to rank my measure :

RankT = GENERATESERIES(1,10)
In column, the brands
And two values :

Q73_Measure category = MAXX(FILTER(ADDCOLUMNS(SUMMARIZE(Q73, Q73[marques.make_lib], Q73[Q73_lib]), "line1", Q73[_%_Q73], "line2", [Q73_Rank], "line3", Q73[Q73_Make_order]), [line2]=MAX(RankT[Value])), Q73[Q73_lib])

and

Q73_Measure percent = MAXX(FILTER(ADDCOLUMNS(SUMMARIZE(Q73, Q73[marques.make_lib], Q73[Q73_lib]), "line1", Q73[_%_Q73], "line2", [Q73_Rank], "line3", Q73[Q73_Make_order]), [line2]=MAX(RankT[Value])), Q73[_%_Q73])

Clement

[clem312]

@v-xiaotang @amitchandak 

Thank you. Finally worked. 
I created a measure MIN(Id_color) in my table and Background color and it worked ! Even without adding id_color in the matrix

[v-xiaotang · Accepted solution]

Hi @clem312 

In your measure, it performs conditional formatting based on Q72_correspondance.Q72_id_color, but this column is not added in your matrix. So if this column can't be added to the matrix, you should look for other column to replace it. Otherwise, it is difficult to perform conditional formatting.

For more details about conditional formatting, you can review this article,

https://www.sqlshack.com/conditional-formatting-in-power-bi-2/

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[clem312]

Hi @v-xiaotang 

Even inserting Q72_correspondance.Q72_id_color in the matrix doesn't change the background color.

[v-xiaotang]

Hi @clem312 

Thanks for your feedback. Could you show me how you set conditional formatting in matrix?

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[clem312 · Accepted solution]

Hi @amitchandak 

Thank you for your answer.

It's hard to put it in the matrix.

In line, I have a series to rank my measure :

RankT = GENERATESERIES(1,10)
In column, the brands
And two values :

Q73_Measure category = MAXX(FILTER(ADDCOLUMNS(SUMMARIZE(Q73, Q73[marques.make_lib], Q73[Q73_lib]), "line1", Q73[_%_Q73], "line2", [Q73_Rank], "line3", Q73[Q73_Make_order]), [line2]=MAX(RankT[Value])), Q73[Q73_lib])

and

Q73_Measure percent = MAXX(FILTER(ADDCOLUMNS(SUMMARIZE(Q73, Q73[marques.make_lib], Q73[Q73_lib]), "line1", Q73[_%_Q73], "line2", [Q73_Rank], "line3", Q73[Q73_Make_order]), [line2]=MAX(RankT[Value])), Q73[_%_Q73])

Clement

[amitchandak]

@clem312 , In this case, Q73[Q72_correspondance.Q72_id_color] should be used in the matrix (or min of the context will be used)

Try like this. Used this measure in conditional formatting using the field values option

Q73_Background Color =
Switch (true() ,

MIN(Q73[Q72_correspondance.Q72_id_color])=1,"#ff99cc",
MIN(Q73[Q72_correspondance.Q72_id_color])=4,"#ccccff",
MIN(Q73[Q72_correspondance.Q72_id_color])=5,"#ffcc99"

)

PowerBI Abstract Thesis: How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4