Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 comparing target values vs actual values like we have in the past. Our data structure currently looks like this when exported out of Asana
I've researched this question in the forums and it seems everyone says to use unpivot to fix the problem, but I don't see a way to unpivot this to make that work. It is not an option to change the format in Asana, our team worked on multiple ways to store that data and this was the best option. Other options would have had even more problems.
Here is an example of the type of graphs we usually would make with this kind of data.
Here is an example of how our data used to be stored. In this format, we stored each department in their own sheet and all numbers were in the same column with a column that stored if it was a budget or actual to filter on.
Does anyone have any advice on how to deal with this problem?
Solved! Go to Solution.
Hi @juliannegibson
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.
Regards,
Marcel Magalhães
Microsoft Power BI Official Partner
MCT | Certified PL-300 Power BI
Hi @juliannegibson
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.
Regards,
Marcel Magalhães
Microsoft Power BI Official Partner
MCT | Certified PL-300 Power BI
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
88 | |
82 | |
65 | |
64 | |
58 |
User | Count |
---|---|
171 | |
112 | |
110 | |
72 | |
72 |