topic Re: Conditional formatting based on Field value on calculated measure in Developer

Conditional formatting based on Field value on calculated measure

Vilas_Techie — Fri, 23 Dec 2022 09:52:29 GMT

I want to apply conditional formatting for CurrentPain

Conditions:1)currentpain> 2022 goal is Red

2) currentpain <= 2022 goal is green

3) currentpain in between 2021 YE pain and 2022 goal is Yellow

How can this be achieved? looks like the rules method only allows for hardcoded values. Is there a workaround for this?

Thanks,

Vilas

@amitchandak

@vicky_

@Greg_Deckler

@Ashish_Mathur

@ lbendlin

@Robert_BI

@Senthil_Kumar

Re: Conditional formatting based on Field value on calculated measure

lbendlin — Sat, 24 Dec 2022 19:35:44 GMT

You can do that via a measure.

Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Conditional formatting based on Field value on calculated measure

Anonymous — Tue, 27 Dec 2022 07:26:21 GMT

Hi @Vilas_Techie,

Any update on this? Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng