Forum Discussion
Filter not working as expected
Thanks for your response, but I can't share my PBIX file. But the issue is that in my file a one to one relationship between "Type" is not being accepted as a valid one and others have a circular dependency issue. And I have a date and type filter (from table 1) on the page which aren't working if they're not having an active relationship between the types or dates.
Community SupportHi Anonymous ,
Could you pls show some sample data with expected output?
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Hi v-kelly-msft,
I can only attach the screenshots since I don't have an attach file option available. The slicers for type and date are from original table and the graph needs to be filtered by both the slicers which is not happening. The only relationship allowed between "Type" of the tables is many to many and then the graph does not get filtered by the date slicer. I tried creating columns in both the tables to have matchable dates - monthly 1st date in original date and a combinevalue column in summarized table and then create a relationship which is not accepted.
- v-kelly-msft
Hi Anonymous ,
If so,create a dimensional table for "Type":
dim table = VALUES('Original table'[Type])Then create relationships as below among the three tables:
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
- v-kelly-msft
Hi Anonymous ,
Is your issue solved？Does my suggestion work ?
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
Apologies for the delay in response, but a one to one relationship is not being allowed between "Type" and thus am not able to resolve it using this, thanks for your response.