Forum Discussion
Solved
Restricted by data structure
Hi, I'm unable to build a chart I would like as my 'values' data is in 3 separate columns rather than 1 column that is categorised by a companion column. This I realise is not the greatest of exp...
- Hi ,
no, you will not have problems with refreshing, because all transformation steps will be repeated every time you refresh you data model. I am happy, when this is the solution you needed ;)
Regards,
Lars
Hi ,
when you have your table in your import dialog mark cost1 and cost2 and click on transform --> unpivot. That should take you to the desired table structure ;)
Hope that helped,
Regards
Lars
when you have your table in your import dialog mark cost1 and cost2 and click on transform --> unpivot. That should take you to the desired table structure ;)
Hope that helped,
Regards
Lars
Great stuff Lars! You have no idea how revolutionary that's going to be for me!
Will I hit problems refreshing data as the data structures are now different?
Phil
- Hi ,
no, you will not have problems with refreshing, because all transformation steps will be repeated every time you refresh you data model. I am happy, when this is the solution you needed ;)
Regards,
Lars