Forum Discussion
Crossfiltering not working
Hi Lydia,
Thanks for replying, you got it right all the visuals come from a single table.
here's the sample data.
I guess it creates problem since all the visuals comes from the one table.
The workaround I see here is to create pivot or transpose where each question and answer will be column instead of row, I know how to transpose however I don't know how to create a pivot, I 'm not sure what would be better could you please help me with some demonstration ?
Hi harsh,
Would you mind sharing me the PBIX file? If you need to create PivotTable, you can take a look at the example in this article : https://support.office.com/en-us/article/Create-a-PivotTable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576?ui=en-US&rs=en-US&ad=US
Thanks,
Lydia Zhang