Forum Discussion

clem312's avatar
clem312
Icon for Resolver I rankResolver I
4 years ago
Solved

Function Background color

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_co...
Need Help
v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
4 years ago

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's avatar
clem312
Icon for Resolver I rankResolver I
4 years ago

Hi v-xiaotang 

 

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

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    4 years ago

    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.