How to Show Specific Data in a Table Based on a Selected Chart

[MDR03]

Hi,

I have two charts in my Power BI report, and I'm trying to display specific data in a table based on the chart that is selected. However, I'm encountering an issue where the data in the table does not update as expected.

What would be the proper way to do this?

Thx in advanced for helping out, have a great day!

[bhanu_gautam · Accepted solution]

@MDR03 , Check interaction by using below steps

Click on the chart that you want to use to filter the data in the table.

Go to the "Format" tab in the ribbon and select "Edit Interactions". This will enable you to control how the selected chart interacts with other visuals on the report page.

Click on the table visual. You will see icons appear above the table. Click on the filter icon (a funnel) to ensure that the table is filtered based on the selection in the chart.

Click on different parts of the chart to see if the table updates accordingly. The table should now display data based on the selected chart data.

[MDR03]

Hi, i tried, it still displays wrong, in the table do i add simple all the columns that i want to be displayed? from both sheets ? ( each sheet is corresponding to a chart )

I saw people saying that I need to use Dax code to acomplish this.
Thx for helping 🙂

[Anonymous]

Hi @MDR03 

Thanks for the reply from bhanu_gautam .

Do you need to click on the chart visualization and then the table visualization shows the corresponding content?

Could you please provide some sample data and expected results so we can help you better? How to provide sample data in the Power BI Forum - Microsoft Fabric Community Or show them as screenshots or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.

Best Regards,
Yulia Xu