Forum Discussion

ManishML's avatar
ManishML
Frequent Visitor
4 years ago
Solved

Measure connected with table cell

I want to make something like : a table is connected with a measure, If the measure value is 5 and in a table if some of the cell having a value greater or equal then that, it simply diffrenciate tha...
measure
Table
  • v-yadongf-msft's avatar
    v-yadongf-msft
    4 years ago

    Hi ManishML 

     

    The measure I created:

     

    Valueness = MAX('Name'[Values])/2

formatting = IF('Name'[Valueness] >= 5,"red")

     

     

    Click “Values” field, check “Conditional formatting”-“Font color”.

     

    Then check “Field value”-“formatting”.

     

    Finally, you can simply differentiate that cell by a color like below:

     

    If I misunderstand your demands, please provide some data screenshots (remember to hide sensitive information) to help us better solve your problem.

     

    Best regards,

    Yadong Fang

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

v-yadongf-msft's avatar
v-yadongf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi ManishML 

 

The measure I created:

 

Valueness = MAX('Name'[Values])/2

formatting = IF('Name'[Valueness] >= 5,"red")

 

 

Click “Values” field, check “Conditional formatting”-“Font color”.

 

Then check “Field value”-“formatting”.

 

Finally, you can simply differentiate that cell by a color like below:

 

If I misunderstand your demands, please provide some data screenshots (remember to hide sensitive information) to help us better solve your problem.

 

Best regards,

Yadong Fang

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