Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Team,
I have below data where I wanted to Highlight YGoalPer as green if the YGoalPer < YestForm else mark the background as green
When I check Conditional Formatting option , I dont see the comparison option there.
Kindly guide.
Solved! Go to Solution.
Hi,
You can do this using the new Power BI feature, released yesterday: Conditional formatting by a different field.
Update Power BI Desktop to the latest version: 2.58.5103.501 64-bit (may 2018)
Create a new column YGoalPer_IsLessThan_YestForm = IF('Table'[YGoalPer] < 'Table'[YestForm];1;0)
And now you can do this:
Regards.
Ohh thanks for useful info, it worked like charm
Hi,
You can do this using the new Power BI feature, released yesterday: Conditional formatting by a different field.
Update Power BI Desktop to the latest version: 2.58.5103.501 64-bit (may 2018)
Create a new column YGoalPer_IsLessThan_YestForm = IF('Table'[YGoalPer] < 'Table'[YestForm];1;0)
And now you can do this:
Regards.
Ohh thanks for useful info, it worked like charm
Can you do this with Data Bars?
I would like to set a maximum number as a measure...
Thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
101 | |
69 | |
69 | |
43 |
User | Count |
---|---|
146 | |
106 | |
105 | |
90 | |
65 |