Filter / Slice by column

[Lena_K]

I suspect the answer is 'its not possible' to this question, but I am hoping there is a trick I'm missing

I have a data set where each row represents an individual - the first group of columns are characteristics about that individual, there is then a group of columns with different measures in.

I have set a report up which shows the measures split by the characteristics of the inidividual.

In the example shown for instance the charts use KS2_ELIGRWM as the value and KS2_RWMEXP as the legend / detail - the various characteristic columns are used for the axis.

The only way I can see to create the same set of charts for the other 2 measures shown (KS2_ELIGREADLA and KS2_ELIGMATLA) would be to duplicate the pages and change the measures manually - however, ideally I would like to be able to put a selector in so that they can be selected on the same page - is there a way of doing this?

[v-chuncz-msft · Accepted solution]

@Lena_K,

You may select Unpivot Columns in the Query Editor first.

[Lena_K]

Fantastic - worked a treat - thank you!