Forum Discussion

chyang0107's avatar
chyang0107
Helper I
1 year ago
Solved

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 visualizat...
  • Jpss's avatar
    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.

  • shafiz_p's avatar
    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