Solved: Re: Highlight data

mrswa_56 · ‎06-23-2020

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 · ‎06-23-2020

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.

View solution in original post

v-juanli-msft · ‎06-23-2020

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 · ‎06-23-2020

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