Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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.
Solved! Go to Solution.
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
Proud to be a Super User!
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:
Proud to be a Super User!
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
Proud to be a Super User!
Can you share a pbix file with a quick example of that? I want to see how you built your measure
Proud to be a Super User!
Thank you for valuable time to read and reply.
Here you can download the pbix file from box.
https://toyotsu.box.com/s/5ohfmo6nu51lj4rtp4oxq1csms4vndfc
User | Count |
---|---|
98 | |
76 | |
74 | |
49 | |
26 |