Forum Discussion
report level filter
OK, glad I'm not going crazy!!
So, if you copied it in Query Editor or did your Copy table and then an Enter Data query and pasted it, it's a real table in your data model now. You should be able to find it in Relationships tab, you might have to scroll over to find it. Once you do that, you should be able to relate it to whatever it needs related to in order to make your report filter work.
Here is a screenshot of one page of my report:
The two visuals on the left come from one table and are simple counts and the large visual comes from the "copy" data table - which I must have copied differently because I just tried to replicate how I copied it previously and was only able to copy to the clip board (you're absolutely correct). I must have copied the table in the Edit Queries window. The reason I even did the "copy table" is that unpivoting one of the survey responses impaced my other visual counts. For example, the top left visual shows the number of respondents by department; once I unpivoted a group of the survey responses, the number of respondents increased by 6 (the number of responses in the group), which is why I was thinking this must be a data modeling issue rather than a report-level filter issue.
I really appreciate your feedback/assistance!
OK, glad I'm not going crazy!!
So, if you copied it in Query Editor or did your Copy table and then an Enter Data query and pasted it, it's a real table in your data model now. You should be able to find it in Relationships tab, you might have to scroll over to find it. Once you do that, you should be able to relate it to whatever it needs related to in order to make your report filter work.
Thank you!