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.
I have two measures - Net Sale and Target.
Both measures are in different tables.
If the Net Sale is below Target, I want to change the font color of Net sale.
Please help
Solved! Go to Solution.
Hi,
Create a new measure for que Color comparing the nets and targets, example:
ColorKPI = SWITCH(TRUE();SUM('Table'[Net])-SUM('Table'[Target])<0;"#FF0000";"#008000")
Then,
Use this measure in the conditional formatting, using the option Format By Field Value
Hi,
Create a new measure for que Color comparing the nets and targets, example:
ColorKPI = SWITCH(TRUE();SUM('Table'[Net])-SUM('Table'[Target])<0;"#FF0000";"#008000")
Then,
Use this measure in the conditional formatting, using the option Format By Field Value
Bro, can you please explain in detail, both measures are in different tables.
My example used two columns in the same table, but you can do with measures in different table (if they have relations) was you shown above.
If my post helped you, I appreciate your Kudos.
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 |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |