Forum Discussion
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 that cell by a color or anything which could highlight.
I tired this, but its not working.
Test2 =
VAR Value = ('Name'[Values])
RETURN
IF (
Value < ('Name'[Valuesss]), "#0E8155"
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.
2 Replies
- Syk
Resident Rockstar
Check out the conditional formatting for the table visual, you can set background color and lots of other settings!
Apply conditional table formatting in Power BI - Power BI | Microsoft Docs
v-yadongf-msftCommunity Support
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.
