Forum Discussion
Post Prodigycolour formating
When you have clicked on the conditional formatting then you should be able to change the format by to field value and then select your measure as the field like below.
If this works then please mark it as the accepted solution.
Post ProdigyThanks for your reply, the table that i keept as referrence is not part of my data base. It is just for referrence. I need the dax baed on the first table. somthing like if(and([parameter]="Ab"),Perfo<=avg[target]),"Green","Red") so it should be like nexted if. But in Power bi it is tough for make somthing like this. Can you help based on this.
I would make the table a part of you datamodel to make the most efficient measure.
But I guess you can make something like the measure below:
formatting = SWITCH( SELECTEDVALUE(Parameter), "AB", IF( [Perfo] <= [Target], "Green", "Red"), "ATT", IF( [Perfo] <= [Target], "Green", "Red"), "ESAT", IF( [Perfo] > [Target], "Green", "Red"), ETC... "Black" )
- unnijoy
Hi Anonymous , this is working. But when i try to use this measue for condetionakl formating the measure is not getting selected. Am i missing somthing. Please advice.
When you have clicked on the conditional formatting then you should be able to change the format by to field value and then select your measure as the field like below.
If this works then please mark it as the accepted solution.
- unnijoy
Hi Anonymous ,
Thank you verymuch... it is working now.