Forum Discussion
Table/Matrix visualization to show current and previous value
Hello,
Thanks for your time in advance. I wonder if you could provide your insights on how to make a visualization by putting two values (Total and Last Quarter) side by side (expected visualization below) using the data source(top).
Thanks,
Hank
Data source (SQL database)
| Project Name | Project ID | TotalPayment | Payment_LastQuarter | TotalExpense | Expense_LastQuarter |
| ABC | 1 | 100 | 80 | 60 | 40 |
Expected visualization(either Table or Matrix)
| Column Name | Total Value | Value_LastQuarter |
| Project Name | ABC | |
| Project ID | 1 | |
| Payment | 100 | 80 |
| Expense | 60 | 40 |
Hello,
Following is the soluition i created for you :here is the pbix file for your reference: Chyang0107 _sol_jpss.pbix
if you find this helpful, Please consider marking it as a solution.
Hi chyang0107 Your expected result is not usable when there is other projects. For example, if you have other project name, DEF and all the other attributes, then how would you visualize them. For one row table as you have provided data, it is possible using power query and matrix visual. See image:
But I think your table have many rows with many different projects. Then solution provided by Jpss is useful by switching values to rows in matrix visual "value option".
Hope this helps!!Best Regards,
Shahariar Hafiz
4 Replies
Hello,
Following is the soluition i created for you :here is the pbix file for your reference: Chyang0107 _sol_jpss.pbix
if you find this helpful, Please consider marking it as a solution.
Hi chyang0107 Your expected result is not usable when there is other projects. For example, if you have other project name, DEF and all the other attributes, then how would you visualize them. For one row table as you have provided data, it is possible using power query and matrix visual. See image:
But I think your table have many rows with many different projects. Then solution provided by Jpss is useful by switching values to rows in matrix visual "value option".
Hope this helps!!Best Regards,
Shahariar HafizHello Shahariar,
Thanks for the insights. You are correct the table contains multiple rows and a dropdown menu was set up for the user to select the project of interest.
Thanks,
Hank
Hi all,thanks for the quick reply, I'll add more.
Hi chyang0107 ,
The steps to see if the attachment meets your needs may not be the easiest, but I think it should meet your needs.
Best Regards,
Wenbin Zhou
