Forum Discussion
Conditional formate for measures
Dear Sir,
Good Day.
I have created one measures it is in Tex formate, we have showing the all data in table vistualization.
Without changing the formate can we apply font condtiona to show the positive values in green color and negative values are in red color.
Thank you in advance.
You have changed your Variance Data measure to my new measure and it's not what you need to do it.
You should put the old version of your Variance Data and create a new measure (for example: Cond Format) with the code I shared in the other post.
After that you need to apply one condicional format for your Variance Data using the "Cond Format".
You can also watch this video:
https://www.youtube.com/watch?v=IgYiWRPqIZU
5 Replies
Can you share a pbix file with a quick example of that? I want to see how you built your measure
Thank you for valuable time to read and reply.
Here you can download the pbix file from box.
https://toyotsu.box.com/s/5ohfmo6nu51lj4rtp4oxq1csms4vndfc
Try this:
Create this measure:After go to:
And choose this Format style: "Field Value" and search for "Cond Format" measure:
The final result would be this:
I tried with the above solution. but bad luck its not working.
its showing like this .
here i have attached the pbix file.
https://toyotsu.box.com/s/5ohfmo6nu51lj4rtp4oxq1csms4vndfc
You have changed your Variance Data measure to my new measure and it's not what you need to do it.
You should put the old version of your Variance Data and create a new measure (for example: Cond Format) with the code I shared in the other post.
After that you need to apply one condicional format for your Variance Data using the "Cond Format".
You can also watch this video:
https://www.youtube.com/watch?v=IgYiWRPqIZU
