Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Try Visual level filter
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
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
Try Visual level filter
Is it possible you've changed the default interaction(s) between the visuals so that clicking on one doesn't filter the other?
User | Count |
---|---|
94 | |
86 | |
78 | |
70 | |
63 |
User | Count |
---|---|
114 | |
101 | |
97 | |
66 | |
59 |