Forum Discussion
Compare two readings and highlight when is a difference
Hello community,
I would like to ask for some help with a problem I have. There are readings that I have to compare: Static Input 1 A/F with Static Input 1 A/L, and same for each 2,3,4,.... In case there is a difference get "Changed", or highlight in red. This visual is a matrix and not sure ih a measure is applicable in this case. Do you have to create a condition for each case? Input 1, Input 2, ... .Any sugestions is welcomed!
2 Replies
- amitchandak
Super User
Anonymous , do want to Compare Categorical Data Using Slicers,
example Compare Two Brands/Categories/Cities: https://youtu.be/exN4nTewgbc
and then do conditional formatting using a measure
How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3Maybe this situation is a bit better to solve. Create a calc column or a measure that will compare the two values from the two selected columns (in this case Static Input 1 A/F and Static Input 1 A/L) and give 1 when equal and zero when different. Those values should be based on the slicer selection (Reading DEscription). So the user have to select the two columns that need comparison.
