Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi Team,
I have below table and created Matric table in PI file, now I need to highlight rows wise if value mismatch.
Solved! Go to Solution.
So if I understood correctly all values in the same category should be the same, otherwise be highlighted. Find attached my proposed solution. I adapted @NikhilChenna 's recommendation into this formula:
Color Logic = IF(SUM('Table'[Cat14]) <> SUM('Table'[Cat15]) || SUM('Table'[Cat14])<> SUM('Table'[Cat16]) || SUM('Table'[Cat15]) <> SUM('Table'[Cat16]), "#FF7F7F", "#FFFFFF")
You would need to pivot your table though, assuming you don't have other data.
Proud to be a Super User!
Hi @Anonymous ,
Please follow the below steps to get your conditional formatting,
These steps should help you achieve the desired result of coloring the entire row when the values in columns 14, 15, and 16 do not match. Adjust the DAX expression and conditional formatting rules as per your specific dataset and requirements.
Regards,
Nikhil Chenna
If your issues resolves select my post as a solution and gives a thumbsup.
Hi @NikhilChenna
If the 14,15 and 16 is the single column then what is the dax function, Please advise
Hi @Anonymous ,
You can try the below ,
=IF([Value] <> EARLIER([Value]), 1, 0)
Regards,
Nikhil Chenna
If your issues resolves select my post as a solution and gives a thumbsup.
What would be the criteria to determine if a value is a mismatch?
Proud to be a Super User!
Which values do you want to compare I meant?
Proud to be a Super User!
So if I understood correctly all values in the same category should be the same, otherwise be highlighted. Find attached my proposed solution. I adapted @NikhilChenna 's recommendation into this formula:
Color Logic = IF(SUM('Table'[Cat14]) <> SUM('Table'[Cat15]) || SUM('Table'[Cat14])<> SUM('Table'[Cat16]) || SUM('Table'[Cat15]) <> SUM('Table'[Cat16]), "#FF7F7F", "#FFFFFF")
You would need to pivot your table though, assuming you don't have other data.
Proud to be a Super User!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
57 | |
38 | |
36 |
User | Count |
---|---|
81 | |
67 | |
62 | |
46 | |
45 |