Forum Discussion
report level filter
Hi! I have a report using a data set of survey responses from surveys administered on several dates. In order to unpivot some of the responses, I made a copy of the original data table in the data tab, and the survey date column was not edited. So one of my visuals is from the copied data table and two visuals are from the original data table. Since I "copied" the data table, it doesn't appear in the relationships tab. I want to do a report-level filter by survey date, but one of my visuals (from the copied data table) is not responding to the filter.
Can anyone please help me? I'm not sure if I'm applying the filtering incorrectly or if I need to do something different with data modeling. Any assistance would be greatly appreciated!
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.
6 Replies
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?
