Forum Discussion
Comparing two tables within a dashboard
I have a power bi dashboard and within that two separate tables with data displayed on one tab, the tables in some case have an identifer that matches in both tables, where this is i want to highlight those green and where we have a non match highlight them in RED, is this possible?
4 Replies
Hi nb790410
Create a separate dimensions table that contains a complete list of IDs and relate that to the two other tables in a one to many single direction relationship
Add the column from the dimension table to a visual. Create this measure and add it to the visual as well.
Test = DISTINCTCOUNT ( T1[ID] ) + DISTINCTCOUNT ( T2[ID] )Apply conditional background conditional formatting to the ID column based on the value of the measure above
Please see the attached sample pbix.
Hi nb790410 ,
Just wanted to check if you had the opportunity to review the solution provided by the Super User?
If his response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Fell free to reach out in case of any issues.
Thank you.Hi @nb790410 ,
Just wanted to check if you had the opportunity to review the solution provided by the Super User?
If his response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Fell free to reach out in case of any issues.
Thank you.
