SandDance does not filter other visuals on a page

[SergiyVV]

trafficstars

@danmarshall There was a similar issue before: #https://github.com/microsoft/SandDance/issues/133

I like SandDance very much, but the lack of interaction with another visuals on a page prevents me from using it. Isolating of selected item allows to filter items inside SandDance visual, but that action won't affect any other visuals on a page, which is very disappointing.

You wrote:

another user requesting this same functionality has pointed out an issue, when the selection contains thousands of data points. This causes the PowerBI UI to hang for several minutes

I can't see the reason for that, but if so, why not make a property that will allow me as a report designer to turn on/off the interaction with another visuals on a page? If you could do such a property, it would be very valuable.

[danmarshall]

Hi @SergiyVV, first of all for this feature to work correctly, the fields must not be summarized. So first, please make sure "Don't summarize" is selected for every field. Secondly, In my PowerBI reports, filtering is working correctly for me. However, I have another user reporting the same issue as you. We aren't able to determine the cause of the issue yet, so any further information you can provide will be helpful. Also if you can try to create an extremely simple report to see if filtering works even in a simple scenario.

[SergiyVV]

Hi, @danmarshall

I made sure "Don't summarize" is selected for every field. It didn't help. As you suggested, I created a file for tests. Here is a link to it: InteractionTest.pbix

At first everything worked as expected. A click on an item of SandDance visual caused filtering of a table next to it. But when I renamed one of the fields in Values well, SandDance visual stopped filtering the adjoining table.

In a sample file I provided there are two identical SandDance visuals. The one that is on top works as expected. The one that is below it does not filter the adjoining table. The only difference between visuals is that I renamed "Progress" to "Progress_RENAMED"

Thank you!

P.S. I forgot to mention that SortByAnotherColumn setting is not taken into account by SandDance visual. Notwithstanding the fact that Status, Priority, Progress fields are sorted by another columns, SandDance visual applies alphabetical sorting order.

[danmarshall]

It may be that renaming the field is causing the selection to break, since the new name may not be a field in the other visual's data.