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.
Hi campbellmurphy ,
Do you just want to present the information has you have it in the last image? or can it be a little bit different?
If it can have a slitgh look and fell use a matrix visualization something similar to this:
If you want the exaxt look and fell you can try and do what is in this blog post:
Hi MFelix ,
I want the data transformed as it is in the image e.g. in a new table (not a matrix) as I need to use each of the new index column numbers as unique variables in visualisations.
The blog post provided manually creates each column which I'd strongly prefer not to do as I'd have 2000 columns which may change data sources over time.
Thanks,
Campbell
