Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
NadeemAhamed
Helper V
Helper V

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.

1 ACCEPTED 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





Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!




View solution in original post

5 REPLIES 5
_AAndrade
Super User
Super User

Try this:

Create this measure:

_AAndrade_0-1708335340483.png

After go to:

_AAndrade_1-1708335409454.png

And choose this Format style: "Field Value" and search for "Cond Format" measure:

_AAndrade_2-1708335522816.png

The final result would be this:

_AAndrade_3-1708335557357.png

 

 

 





Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!




I tried with the above solution. but bad luck its not working. 

 

its showing like this .

NadeemAhamed_0-1708337499698.png

 

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





Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!




_AAndrade
Super User
Super User

Can you share a pbix file with a quick example of that? I want to see how you built your measure





Did I answer your question? Mark my post as a solution! Kudos are welcome.

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

 

 

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors