Visual Calculation Formatting

[AllanBerces]

Hi Good day,

How to turn red if negative and green if greaterthan 0 on the visual calculation.

Thank you

[Anonymous · Accepted solution]

Hi @AllanBerces ,

Thanks to Greg_Deckler  and NaveenGandhi  for their quick replies. As Greg_Deckler said, due to limitations you can't apply conditional formatting on visual calculations.

But you can create a table visual object and then set the conditional formatting.

(1) This is my test data.

(2) Create a column.

Delta = [Actual]-[Plan]

(3) Create a measure.

Color = SWITCH(TRUE(),
SELECTEDVALUE('Table'[Delta])>0,"green",
SELECTEDVALUE('Table'[Delta])<0,"red")

(4) Setting the Conditional Format.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[Greg_Deckler]

@AllanBerces Visual calculations are a preview feature and currently formatting is limited to non-existent. To the best of my knowledge there is no conditional formatting for visual calculations at this time. You'll probably have to wait until Fabric Desktop is released.

[NaveenGandhi]

Hi @AllanBerces 

You can use conditional formatting. Below document is a good start.

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting

If you still have difficulty, please share sample file or data and expected output as screenshot to understand the problem better.

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

Follow me on LinkedIn!!!