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 2 matrices.The 1st row in matrix is the count of all accounts(account_id) in all firms. After expanding the counts, we can see firms(firm_id), and after expanding the firms(firm_id) we can see accounts (account_id). As we can see there is a mismatch in th records of Master and Hubs. Master has 84020 accounts and Hubs have 33272 accounts. The task is to highlight/add icon beside the firm_id on both matrices that have mismatch in the count of accounts. Eg: Hubs_Firm_id 60 has 30 accounts in it and Master_firm_id 60 has 45 accounts in it, the we want to highlight Firm 60 in both matrix. I am new with PowerBI and am learning and figuring out things here.
Hi @saylee ,
I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting and desensitized example data.
Thanks for your efforts & time in advance.
Best regards,
Community Support Team_ Binbin Yu
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 | |
106 | |
86 | |
73 | |
66 |
User | Count |
---|---|
124 | |
113 | |
98 | |
81 | |
72 |