How to color measure value with condition in tableau?

table:

id    category    qty    sales_2017   sales_2018  1     pen          5       5000         7000  1     pen          8       15000        7000  1     pen          9       15000        7000  2     pencil       6       5000         17000  2     pencil       1       5000         14000  2     pencil      10       5000         7000  

output:

category   qty   sales_2018(sales_2018-sales_2017)  pen        22     35000(-14000)  pencil     17     15000(20000)  

i need to get output like this, with the color formatted which are in bracket if it is negative then red else green.

https://stackoverflow.com/questions/66721211/how-to-color-measure-value-with-condition-in-tableau March 20, 2021 at 07:49PM