Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!
Solved! Go to 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.
Proud to be a Super User! |
|
@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.
Proud to be a Super User! |
|
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 🙂
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
25 | |
15 | |
14 | |
14 | |
9 |
User | Count |
---|---|
31 | |
20 | |
15 | |
15 | |
14 |