Forum Discussion
Multiple Filters on one Slicer
Hello,
I've downloaded forecast data from 3 tables (FP, RF1, Actuals) that contains name of supplier, the period of spend (e.g. month, full year, quarter etc) and the actual spend in that period. I want to be able to filter by supplier and then by period to show me period specific spend for any supplier I wish to choose so I can see comparison of the different forecasts on one graph. However I can't create multiple relationships so it allows me to filter by supplier but it shows me total spend no matter which period I try to filter. Vice versa when I create a relationship between period it allows me to filter by period but shows me all the combined supplier spend. Any help would be greatly appreciated.
Thanks!
3 Replies
Hi tommat01,
If i am understanding it correct, you have 3 seperate tables with data.
A quick fix would be to create two dimension tables, date (calendar) and supplier.
You then create a releationship between these and your tables. You can use the two new tables to filter the rest.
Some resources:
https://learn.microsoft.com/en-us/power-bi/guidance/model-date-tables
https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
tommat01 wrote:Thanks for your response! With the dimensional tables - what would be included? Would it be just one table with one column of just suppliers and another table with one column of periods?
Yes 🙂
Screenshot is with 4 tables, two DIM tables and two FACT tables
Now you can just create a measure to get the difference between the values.
