Forum Discussion
Old Table (or fix new one?)
Bump.
Is no one else really having a problem with this? :( What's the point of having charts and tables interact with eachother if the table is going to reset once you click a single cell?
- GilbertQ9 years ago
Super User
Hi CA
If I understand correctly, what you could do is to Edit the interactions and disable any interaction happening from another visual onto your table.
And here is a link to how the Interactions work: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-visual-interactions/
- CA9 years agoFrequent Visitor
Nope, doesn't solve the issue.
I've created an example and put it in Dropbox: https://www.dropbox.com/s/d6ivffzxby82smx/exampleofchangedtablebehaviour.pbix?dl=0. I also made clarified steps so it's easier to understand what I'm trying to say.
Steps:
1. Click the "Open" piece of the Pie Chart
2. Notice how the Table Visual displays on tickets with the "Open" status
3. Click any cell in the Table Visual
4. Notice how the Table Visual highlights the cell, but also now displays the rest of the tickets, regardless of being in the "Open" status or not
Result:
Visual Table no longer respects the filter of the Pie Chart. The Visual Table instead highlights the cell's data points on the other Visuals (i.e. will show a single "Open" highlight on the Pie Chart).
Expected Result/Behaviour in Previous PBI version:
Clicking a cell in the table does not reset the filter of the Pie Chart. Only tickets in the "Open" status should display in the Table Visual and other tickets remain hidden. Data points on other visuals are not affected.
In effect, Chart Visuals were kind of acting like Slicers when it came to their interactions with Table Visuals. Now this is no longer the case.
Notes:
You can try the same with the Stacked Bar visual at the bottom of the example. Click "Mr.X" and see how the Table Visual shows the four tickets assigned to him, then click any cell in the Table Visual. The Table Visual will revert to showing all the tickets instead of just the tickets assigned to Mr. X.
Impact:
Before, the User could click a piece of the Chart Visual to show the desired tickets in the Table Visual and begin opening URLs in one go (since the Table Visual would respect the Chart Visual's filter). Now, the User will need to click a piece of the Chart Visual, click the URL, click the Chart Visual, click the URL, etc etc, until all tickets can be opened.
This is what I meant by "What's the point of having charts and tables interact with eachother if the table is going to reset once you click a single cell?"
- v-sihou-msft9 years ago
Microsoft Employee
GilbertQ is correct. You need to edit the interaction from Table visual to Doughnut chart. Change it from "Hightlight" into "Filter".
Regards,
- CA9 years agoFrequent Visitor
Unless there is a bug on my system, no, that is not the correct solution. I don't believe either of you are understanding the problem. I've now created a video to better show what I'm talking about. Please view it.
- v-sihou-msft9 years ago
Microsoft Employee
For previous version table, there's no interaction on cell, which means it will not highlight/filter other visuals when you click on any cell. Now, for new table visual, if you click on a cell, it will work like a slicer which will highlight/slice other visual. This will apply a slicer on entire visual, not under current slicing, which means it will reset the filter.
Regards,