Forum Discussion

Zeen's avatar
Zeen
New Member
4 years ago
Solved

conditional format color coding dynamic in power bi

Hello team,    I am new to this community and power bi Dax, I am facing challenges with 2 things -  I have a matrix, part of which needs conditional formatting of a column based on the values of t...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi Zeen ,

    According to your description, I download your file and here's my solution.

    1.Conditional formatting is for visuals not data table. In the visual formatting pane>Cell elements, turn on the Font color option.

    Select the Color Coding column in the dialog.

    Get the correct result.

    2.According to your formula, in 202212, all rows should be blank except "SIERA FC1 2021" data type, it's correct.

    In page1, I change the column Data Type to calculated column Data.Type, not find anything wrong.

    I attach my sample below for your reference.

     

    Best Regards,
    Community Support Team _ kalyj

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

     

     

     

dcrosseto's avatar
dcrosseto
Icon for Resolver II rankResolver II
4 years ago

Hi Zeen,

 

About the color condition, you can apply the formula you created Color Coding following this path below

 

https://prnt.sc/S6i-VcqWerD6

https://prnt.sc/GgcMWYr7_-UF

 

Regarding to the calculated column, I could not understand what you're expecting to see, could you create some illustration with the difference? Like Actual vs. Expected

 

Regards,

Douglas.