Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

How to create graphs using budgeted vs actual data from two different columns?

Our team has recently moved our data collection over to Asana to help with collection and organization. I am much happier with this change but am struggling to figure out how to create our graphs com...
  • marcelsmaglhaes's avatar
    2 years ago

    Hi Anonymous 

    In fact, the best way I can see is pivot columns Target Value and Actual Value. You can load the data from ASANA and use the Unpivot Columns in Power Query. See the images bellow.