Forum Discussion
Table/Matrix visualization to show current and previous value
- 1 year ago
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.
- 1 year ago
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
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