Table visual filtering

[marvicf]

Hi,

I have a Power BI report with a synoptic and a table visual on the same page. Table visual has lots of rows and when I click on a particular item in the synoptic the table visual gets filtered according to what was clicked, which is good. 

The problem is that if I then click on a row of the table visual (which is showing filtered data) the table visual reloads all rows and as such the clicked row is lost. Is this expected behaviour?

Thanks

[v-henryk-mstf · Accepted solution]

Hi @marvicf ,

As you said , this is the mechanism that works in pbi table visual. But when a row is selected, you can hold down ctrl and continue selecting other rows (the previous row does not disappear).

crtl+chosen row

Please point out if you misunderstood your requirement and provide a screenshot of it and describe it so that I can answer it for you as soon as possible. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lzykmr]

Yes. This is the way Power BI filtering works. To solve this you can have the slicer for the dimension that you are using in table. In this way you will be able to get the filtered result based on that dimension too.

I hope this answers your query.