Forum Discussion
Keep rows with unmatching data when filtering
I'm wondering how you would select the color yellow, if the color is just in your sales-table, but no yellow bikes have been sold sofar.
I personally would no relate the sales and the targets table, but would use separate "dimension" tables like "product" and "year", then you can relate these tables to your "fact" tables: sales and saltestargets. Then you can use the color column from the sales-facts to slice your sales data.
Please be aware, that in my example the direction "Cross filter direction" of the relationships should be set to "Single".
Hope this helps
Agree with Tom. This link might be helpful: http://exceleratorbi.com.au/multiple-data-tables-power-pivot/
Super UserI'm wondering how you would select the color yellow, if the color is just in your sales-table, but no yellow bikes have been sold sofar.
I personally would no relate the sales and the targets table, but would use separate "dimension" tables like "product" and "year", then you can relate these tables to your "fact" tables: sales and saltestargets. Then you can use the color column from the sales-facts to slice your sales data.
Please be aware, that in my example the direction "Cross filter direction" of the relationships should be set to "Single".
Hope this helps
- ImkeF
Community Champion
Agree with Tom. This link might be helpful: http://exceleratorbi.com.au/multiple-data-tables-power-pivot/
Hi Imke!
Thanks for the link, will have a look at it.
Hi Tom!
Thanks for the advice, will look into it and let you know how it went. Hopefully I get time to do it this week, not sure though. I'll make sure to mark this answer afterwards.
Regarding the yellow bikes i simplified the truth a little bit. Like you say they must exist to be able to filter them. Translated to this scanario, thare are actually yellow bikes sold, but not in Spain for these years. Other countries might have them :-)