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.
Sorry, how exactly did you copy the table in the data tab? Unless I am mistaken, the "Copy table" option in the data tab is for copying the data from a table into something like Excel, not actually making a copy of the table in Power BI Desktop. So, I am not sure how you would have created a visual from that. Now, you could go into Query Editor and make a copy of a query and that would result in a duplicate table in your data model.
Hi smoupre! I right-clicked on the table (right) in the data tab (left):
OK, right, to the best of my knowledge, all that does is copy the contents of the table into the clipboard, it does not actually make a copy of the table in the data model, so you couldn't have created a visual from a copy of the data because no copy of the data actually exists in the data model.
Unless I'm just way wrong on this.
I guess what I am saying is that I think that your issue lies somewhere else regarding your report filter rather than the copied table thing. Can you provide more information on your visuals and where they are getting their data?
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.