Forum Discussion
Conditionally Format Values Based on User Defined Values
Assuming you have a table with the priority field and values to calculate the [Service level] measure & a target table as shown, with this model:
and this measure to use for field in the conditional formatting options:
Condit Format = IF([Service Level] > SELECTEDVALUE(Targets[Target]), "Green", "red")Add the priority field from the target table to the visual & the [Service Level] measure, and the apply the conditional formatting using the measure above to get:
I've attached a sample PBIX file
Assuming you have a table with the priority field and values to calculate the [Service level] measure & a target table as shown, with this model:
and this measure to use for field in the conditional formatting options:
Condit Format = IF([Service Level] > SELECTEDVALUE(Targets[Target]), "Green", "red")Add the priority field from the target table to the visual & the [Service Level] measure, and the apply the conditional formatting using the measure above to get:
I've attached a sample PBIX file
Thank you so much! This works beautifully. I really appreciate it