Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

How to link a table to a chart

I have a simple stacked column chart, counting actions in different categories per month. 

 

You can drill into each month to see the breakdown of the actions in the categories. 

 

Each of the actions that is being counted has an associated text field with it that I would like to display in a table. 

 

I am having trouble making a table link to the column chart so that as you drill down and click on specific columns, the table update to show just that relevant item and assocuated text field.

 

Any suggestions on how I could make this scenario work?  

 

Thanks! 

1 Reply

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    Hi Anonymous,

     

    If I understand correctly, when you drill down to to each month to see categories, and click the column, you want the table to display corresponding Text field related to checked action in the chart, right?

     

    Assume one table contains fields: Action, Category, Month, the other table contains fields: Action, Text. There is a relationship based on Action column between those two tables. Then we can set the table can be filtered by the chart via Edit Interactions option. See:

     

     

    You can take a look at attached .PBIX file. If it doesn't meet your requirement, please share some sample data and desired for our analysis.

     

    Best Regards,
    Qiuyun Yu