Highlight data

[mrswa_56]

Hi experts,

In a graphical (POWER BI) presentation, data is retreived from Excel sheet automatically. When a entered data point deviates Target/Goal how to highlight that dat (in graph) from others. 

Can any body help me.

[v-juanli-msft · Accepted solution]

Hi @mrswa_56 

As Mariusz suggested, create a measure and apply it in conditional formatting.

Measure = IF(SUM('Table'[value])>=SUM('Table'[goal]),1,0)

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Mariusz]

Hi @mrswa_56 

You can use conditional formatting based on a measure, please see the example below.

https://community.powerbi.com/t5/Desktop/Conditional-Formatting-based-on-Average-Value-of-Measure/m-...

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn