cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
aravindan93 Frequent Visitor
Frequent Visitor

How to Change the cell colour if i have negative value

Capture.PNG

 

I need to change the colour of the cells in the coloum if the diffbwcol is negative to red if positive green

2 ACCEPTED SOLUTIONS

Accepted Solutions
v-yulgu-msft Super Contributor
Super Contributor

Re: How to Change the cell colour if i have negative value

Hi @aravindan93,

 

You can set conditional formatting for DiffBwCol column. Please be aware that the column should be summarized by any of the listed aggregation function. Or it should be a measure. Otherwise, conditional formatting will not be available.

2.PNG

 

Here are two ways to set.

1.PNG

 

Another option.

 

3.PNG

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ross73312 Super Contributor
Super Contributor

Re: How to Change the cell colour if i have negative value

While you have the visual selected, look for your field in the 'Visualisations' pane.  It should be in the area called 'Values'.  Click on the drop arrow next to your column name and select 'Conditional Formatting' -> 'Background color scales'

 

From here use the tick box for "Color by rules".  Set up those 2 rules you just specified.


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


5 REPLIES 5
v-yulgu-msft Super Contributor
Super Contributor

Re: How to Change the cell colour if i have negative value

Hi @aravindan93,

 

You can set conditional formatting for DiffBwCol column. Please be aware that the column should be summarized by any of the listed aggregation function. Or it should be a measure. Otherwise, conditional formatting will not be available.

2.PNG

 

Here are two ways to set.

1.PNG

 

Another option.

 

3.PNG

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
aravindan93 Frequent Visitor
Frequent Visitor

Re: How to Change the cell colour if i have negative value

Hi,

I had actually created a custom column that is diffbwcol=([Open]-[Close])/[Close]*100

so I am not able that summarization

so for the diffbwcol if there is neg i should change it to red if positive i should change it to greenCapture1.PNGtableCapture2.PNG

Ross73312 Super Contributor
Super Contributor

Re: How to Change the cell colour if i have negative value

While you have the visual selected, look for your field in the 'Visualisations' pane.  It should be in the area called 'Values'.  Click on the drop arrow next to your column name and select 'Conditional Formatting' -> 'Background color scales'

 

From here use the tick box for "Color by rules".  Set up those 2 rules you just specified.


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


aravindan93 Frequent Visitor
Frequent Visitor

Re: How to Change the cell colour if i have negative value

No, I don't find it in the value and it is not a measure

aravindan93 Frequent Visitor
Frequent Visitor

Re: How to Change the cell colour if i have negative value

I created the diffbwcol to a measure so now I am able to see the conditional formatting 

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 26 members 902 guests
Please welcome our newest community members: