Forum Discussion

harsh's avatar
harsh
Helper I
9 years ago

Crossfiltering not working

    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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

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's avatar
    harsh
    Helper I
    9 years ago

    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 ?