Forum Discussion
Pivot or Transpose Table using DAX rather than Power Query
Looking at your updated information you don't need to pivot the information, if you use the Index column on the legend of the visualizatiions and change the X-axis according to your needs you can do it has you need, further more yoiu can create an hierarchy with the index and location.
Or do you have some other needs in terms of visualization that is not explained in the example you have?
I used a slicer to filter information by index.
In general, you should not pivot your data like this. Please describe/show your desired final visual that you believe requires this format, so that an alternate approach can potentially be suggested.
Pat
Hey mahoneypat,
Thanks for the feedback. I've updated my original post and the associated example power bi file. The most obvious alternative solution I can think of is to use ADDCOLUMNS when creating a new table within DAX with each new column being filtered for a particular index. This doesn't scale well over 1000 columns which are likely to change into the future though. Your feedback is greatly appreciated.
Cheers,
Campbell
Looking at your updated information you don't need to pivot the information, if you use the Index column on the legend of the visualizatiions and change the X-axis according to your needs you can do it has you need, further more yoiu can create an hierarchy with the index and location.
Or do you have some other needs in terms of visualization that is not explained in the example you have?
I used a slicer to filter information by index.
