Forum Discussion
Creating a Column Chart Affected by Multiple Slicers
Hi red_ltxj,
You should create a separate table with countries and a measure which takes countries from this new table. For example, a combination of CALCULATE and TREATAS will do - please check the attached file with the example.
Best Regards,
Alexander
Hi red_ltxj,
The separate table is not connected with the main one, and the slicers that are based on the columns of the main table cannot affect the standalone table.
Should you want to achieve such a behaviour, you can either create a filtering measure and apply to the slicer based on the separate table (in the filter pane) or do a bit of modelling and create an additional table for each column that is supposed to affect the selection, connect each of them with the main table and standalone one.
Please check the attached files.
Best Regards,
Alexander
That worked, thank you so much for your effort on helping me out. 🙂