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.
Hello All,
I have 2 measures that shows today total and yesterday total.
My aim is to compare yesterday total to the today total , and highlight the today value in red or green depending on if it is higher or lower than the yesterday.
I know conditional formatting feature on values in table or matrix but is it possible to compare with other column's actual value?
Solved! Go to Solution.
On the diff of two, you can use color formatting.
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting
Or you can create a color measure and use that after choosing "field" in conditional formatting
Color = if([Sales Today] -[sales yesterday]>0,"green","red")
On the diff of two, you can use color formatting.
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting
Or you can create a color measure and use that after choosing "field" in conditional formatting
Color = if([Sales Today] -[sales yesterday]>0,"green","red")
It's difficult to see, but in the formatting section of the visualizations pane, if you hover over one of the data color fields, you will get 3 dots to the right. Click the 3 dots to access conditional formatting.
https://docs.microsoft.com/en-us/power-bi/visuals/service-tips-and-tricks-for-color-formatting
I have not tried that.. I am actually looking for directins on how to create this measure and how to use it to change color ?
You can make a measure similar to
IF( [yesterday total] > [today total],
1,
0
)
Then in the conditional formatting area of data colors, you can use this measure as a rule.
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 |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |