display TEXT values instead of measure in pivot table

[Anonymous]

hello,,,

I have a data source like 

member_id	Q	Answer
1	1	yes
1	2	no
1	3	yes
2	1	yes
2	2	yes

the Questions may increase with time to time... 

When I build a pivottable in power bi .. its something like

member_id	answer	1	2	3
1	yes	1		1
2	yes	1	1
1	no		1
2	no

what I want to display is something like

member_id	1	2	3
1	yes	no	yes
2	yes	yes

can you help with tips to do it... as I told before questions mey increase so I dont want to change them into columns in the data source however it will change the structure everytime a question added...I want something dynamic and its structure doesnt change with Question Increase

[CNENFRNL]

That's all. Way much easier beyond expectation.

[Anonymous]

wow... this is great .. but actually I cheated... Im using SSAS and its MAX() function only accept numric values

[CNENFRNL]

I cope with it this way just because I'm used to writing measure myself; in fact, it's not mandatory to use a measure here. Just drap column [Answer] into Values box and it works like my solution.

[v-easonf-msft · Accepted solution]

Hi,  @Anonymous 

I think the matrix visual  should be able to meet your needs.

Please let me know if I have misunderstood.

Best Regards,
Community Support Team _ Eason

[mussaenda]

Hi @Anonymous ,

by Pivoting the column Q,

use Answer on Values Column

and click Advanced options

Choose Don't Aggregate.

It will achieve your desired output.

Hope this helps

[Anonymous]

that is an option on power query if Im not mistaken...

which mean the table will contain new columns every time a Question added which mean a pivot table That I built miss those new questions until I click on them on the self service...

what I want is that my pivottable columns will updated aoutumaticly = (questions must stay on rows on the datasource without any change on source nither using query editor).. Im searching workaround using pivot table options... or costomized dax equation to display a text answer for question iinstead of normal aggregation