Forum Discussion
Multiple variables on x axis? Stacked column visualization
Microsoft EmployeeHi Anonymous,
In Query Editor mode, please unpivot table to convert its structure to below format.
Place [Questions] onto X-axis and place [Answer] into legend of a stacked column chart.
Best regards,
Yuliana Gu
So, I got it to work but now that it created multiple rows, it shows each person took the test multiple times instead of just once. Any way to get the non unpivot columns to only show a value once?
For example, if bob took 1 test with 30 questions, I need Bob to show only 1 test and not 30 tests. Hope this makes sense
Can I make a copy of the table, strip out everything but name, test date and the new unpivot column and value column then use that new table to get visualizations on the test questions? That way my other visualizations are not impacted?
- v-yulgu-msft
Hi Anonymous,
For example, if bob took 1 test with 30 questions, I need Bob to show only 1 test and not 30 tests. Hope this makes sense
Not very clear about your requirement. Does DISTINCTCOUNT meet your requirement? Please illustrate your scenario with some sample data.
Can I make a copy of the table, strip out everything but name, test date and the new unpivot column and value column then use that new table to get visualizations on the test questions? That way my other visualizations are not impacted?
Of course you can.
Regards,
Yuliana Gu
- v-yulgu-msft
So this has been working well for me but now my refresh times are taking an hour to complete and I'm thinking it's because of the duplicate tables being updated at the same time. Could that be a reason?