Forum Discussion

ignas's avatar
ignas
Icon for Advocate II rankAdvocate II
7 years ago

Need help with filtering

Hey there,   It is a simple example of what I need to achieve:   If I select the answer "ddddd" then  the table should show all the answers from the "recipientID" answers, not only the answ...
Need Help
Show and Tell
MFelix's avatar
MFelix
Icon for Super User rankSuper User
7 years ago

Hi ignas ,

 

Not aware that you had such a big database, it was not clear on your message.

 

In my example it is also creating an additional table on the model, because looking at interactions between the visuals if they are from the same table they will filter out the information so you are being a victim of the setup of the data.

 

If you have a single table and you have a slicer and a chart when you apply filter on the slicer the corresponding visual will have the same filter you cannot dissociate one from the other since they are within the same table.

 

Regards,

MFelix

 

 

Iamnvt's avatar
Iamnvt
Icon for Continued Contributor rankContinued Contributor
7 years ago

hi,

 

maybe you can create another visual for "ddddd" filter alone, and hide the "ddddd" option from the slicer.

Create this measure:

Measure = CALCULATE(COUNT(Survey[RecipientID]), Survey[Answer] = "ddddd")

to do the visual filter for "ddddd" table.

unlink the visual interaction between slicer and "ddddd" table.

 

you can check PBI here:

https://1drv.ms/u/s!Aps8poidQa5zk6p365C2AuB5YH8Lxg