Forum Discussion
conditional formatting with icon or colour that compare two columns in percentage changes?
Dear all : good day here, thanks for letting me to post the question here and thanks for your time on reading this. I have a matrix dummy here that I would like to ask how can I add ie : it...
v-yalanwu-msft
Community Support
Community SupportHi, hkbs ;
You could create measure as follow:
78dis = DIVIDE(SUM('Table'[78-SHOP1SOLD]),SUM('Table'[78SHOP2SOLD]))then set the condition format.
and such as other discount.
The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi thanks or the suggestion I tried the methods mentioned , ie how ever if say item 1 85-shop1sold if the value is 100000 , I was expecting the 100000 in highlighted as a result the 85shop2 should not be highlighted, can this be done?