I think I'm just tired tonight because I know I've done this before, but I have 3 data tables (+calendar & type tables). I have linked the tables thorugh a relationship with the calendar table and "type" table, and can filter by type/date, but I also want to be able to filter by shipped or received. Currently when I add the filter for direction, only the table the filter is coming from will change. I tried appending the data but then I can't get it to split apart correctly in the visual.
My columns in all 3 data tables are date, source, type, direction (ship or receive), units.
Example of one:
| Date | Source | Type | Direction | Units |
| 1/1/24 | Online | Small | In | 10 |
| 1/1/24 | Retail | Medium | Out | 20 |
| 1/2/24 | Online | Medium | Out | 30 |
| 1/2/24 | Store | Small | In | 15 |
1 ACCEPTED SOLUTION
Hi @LCook ,
Taking into account what you refer you need to also have a dimension table for the Direction with the values In / Out and then relate with the 3 tables that will create a start schema for each table that will allow you to filter all of them at once has you do for the calendar.
Regards
Miguel Félix
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @LCook ,
Taking into account what you refer you need to also have a dimension table for the Direction with the values In / Out and then relate with the 3 tables that will create a start schema for each table that will allow you to filter all of them at once has you do for the calendar.
Regards
Miguel Félix
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Check out my blog: Power BI em Português
