Crossfiltering not working

[harsh]

Hello all,

As shown in the pic, I have 3 columns and out of that 4 visual representations are created, the problem is if I select in one visual interaction its not reflecting in other it shows "0" count or blank result in other visual interaction, what should I do to make it crossfilterable ?

Note : all the visuals are marked highlighted(not disabled).

[v-yuezhe-msft]

Hi @harsh,

Based on your description, when you click sections in the pie chart, other three visuals are not cross highlighted even if you enable Highlight interaction, right?

If so, the issue could be caused by that there are no values in the other three visuals associated with that section in pie chart.
Do you create these visuals using different columns of different tables or a single table? If the underlying fields of these visuals come from different tables, are there any relations between these fields and do you configure proper relationships among the tables? You can follow the instructions in this article to manage relationships in Power BI Desktop.

If the underlying fields of these visuals come from a single table, please help to share sample data of your table to us for further analysis.


Thanks,
Lydia Zhang

[harsh]

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 ?

[v-yuezhe-msft]

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...

Thanks,
Lydia Zhang