Forum Discussion
Matrix displays the same category twice
Hi, I am really struggling to understand this behaviour. I have a source of 2 excel tables, one from each year. Both contain different set of questions, but some are matching. I have created ...
v-chenwuz-msft
Community Support
Community SupportHi sampak88 ,
Please check if the first Aware of... and the second Aware of... is the same, maybe there is a space in the end of the string. You can change it into table visual and with one measure to count it rows. If the result is two rows will confirm my guess.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The two were exactly the same, I used a different tool and it worked fine there, not sure what caused it as I didn't try to explore it further.