Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Filter not working as expected

Hi,   I created a new table using summarizecolumns() and both the new table and source table have a column "Type". I have a dropdown filter for Type on the page which is not impacting the values of...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
v-kelly-msft
Community Support
5 years ago

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,
Kelly

Did I answer your question? Mark my post as a solution!