Forum Discussion
Function Background color
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])andQ73_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])
ClementHi 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.
Hi v-xiaotang
Even inserting Q72_correspondance.Q72_id_color in the matrix doesn't change the background color.
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.