Forum Discussion
Filter for a comparison graph
I have a graph that I have built using data from 2 different tables comparing weekly purchases of 2021 and 2022. I have created a relationship between these 2 tables using the week column which i have used to plot the x axis. I would like to add a filter on the report that should filter the location however it only filters one of the tables. This location column is also a common column between the 2. Please assit how i can make a filter for location that should work for both tables.
Hey Pru1 ,
Power BI doesn't know about the relationship between locations. That's why only one table is filtered when you try to filter.
If you build your datamodel like this, you are able to filter on locations:
The Location table as all distinct location values. The week table as one column with values 1 tm 53.
Use the location table to filter on your graph.
4 Replies
Hey Pru1 ,
Power BI doesn't know about the relationship between locations. That's why only one table is filtered when you try to filter.
If you build your datamodel like this, you are able to filter on locations:
The Location table as all distinct location values. The week table as one column with values 1 tm 53.
Use the location table to filter on your graph.Thank you so much! It has worked
Print screens above. Thank you!
