Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
91 | |
81 | |
65 | |
65 | |
60 |
User | Count |
---|---|
170 | |
114 | |
102 | |
73 | |
69 |