Date Slicer not working with my table

[michael_knight]

Hi,

I've come across a problem in my report. 

Whenever I click on certain month in a visual, it should only show that month in the table, however it is showing all the data in a table. 

I created a new report with only the two visual from within the image above and it works fine so I think there is another problem in my main report that I'm unable to identify

I'll add a file because I'm not sure where the problem lies 

https://www.dropbox.com/s/97dx1n2s00x2mzm/Market%20Value%20Test.pbix?dl=0

Any help would be much appreciated

Regards,

Mike

[GetResponsive]

Hi @michael_knight 

Reason for your problem is the slicer you have added (Target=105)

This target field is coming from another table than where your amounts/dates are stored. There is no link between the tables, therefore Power BI shows ALL records for the table. Also if you select a single month in the barchart.

See if you can add target to same table, or link the tables together on a key

Hope this helps

BR

Jeroen Heerschop

Get Responsive

[michael_knight]

Hmm, well that's a bit annoying. I had a bit struggling trying to get the Target into my report in the first place. From what I know of Generate Series (I don't know much) is that it has to be in a seperate table. I'm not sure how I would go about creating a link between the two tables 

[amitchandak · Accepted solution]

Try Visual level filter

[michael_knight]

Brilliant, nice one.

Appreciate the help @jthomson  , @GetResponsive and @amitchandak 

[jthomson]

Is it possible you've changed the default interaction(s) between the visuals so that clicking on one doesn't filter the other?