Forum Discussion
Helper ITable/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
