Table/Matrix visualization to show current and previous value

[chyang0107]

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

[Jpss · Accepted solution]

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.

[Anonymous]

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

[shafiz_p · Accepted 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

[chyang0107]

Hello 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

[Jpss · Accepted solution]

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.