Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |