Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello ,
I am converting excel report into power bi report.I have multiple table visulization and matrix visulizaiton in my report.Please see below dataset and final result table.In excel we can give cell reference but here How can I give TOTAL Reference(Prodcut A & Product B) in final table visulization.
Table Visulizaiton SAMPLE DATA 1 | Table Visulizaiton | |||
Product A | Quantity | Product B | Quantity | |
A | 100 | P | 200 | |
B | 200 | Q | 300 | |
C | 300 | R | 400 | |
Total | 600 | Total | 900 | |
Final Table Visulization | ||||
Product A | 600 | |||
Product B | 900 | |||
Total A+B | 1500 |
Solved! Go to Solution.
Hi @Anonymous,
Based on my understanding, your data in visualization1 and visualization2 is from two different datasets, right? If so, to get the final output in Power BI desktop, you could create a calculated table like below, then, add it to table visual.
Final Product table = UNION ( ADDCOLUMNS ( SUMMARIZE ( 'ProductA Table', "Quantity", SUM ( 'ProductA Table'[Quantity] ) ), "Product", "ProductA" ), ADDCOLUMNS ( SUMMARIZE ( 'ProductB Table', "Quantity", SUM ( 'ProductB Table'[Quantity] ) ), "Product", "ProductB" ) )
Best regards,
Yuliana Gu
Hi @Anonymous,
Based on my understanding, your data in visualization1 and visualization2 is from two different datasets, right? If so, to get the final output in Power BI desktop, you could create a calculated table like below, then, add it to table visual.
Final Product table = UNION ( ADDCOLUMNS ( SUMMARIZE ( 'ProductA Table', "Quantity", SUM ( 'ProductA Table'[Quantity] ) ), "Product", "ProductA" ), ADDCOLUMNS ( SUMMARIZE ( 'ProductB Table', "Quantity", SUM ( 'ProductB Table'[Quantity] ) ), "Product", "ProductB" ) )
Best regards,
Yuliana Gu
Thank you so much Yuliana.
User | Count |
---|---|
98 | |
91 | |
84 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |