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 Barritown,
Thanks for the reply, and that worked. However, I've come across a problem. When I try to copy and paste the chart to create charts for different indexes (in this case Groceries Index), the charts come up as blank. In fact any chart that is added to the page will come up as blank. But, In the pbix. you attached, the charts copy and paste just fine.
Also, may I know how you created the 'countriesTbl' table and the 'Country' column in the example you sent? I did it by first creating a Field Parameter and then using the DISTINCT function you used to create the 'Country' column in that table, so I wanted to confirm if this was the correct way.
Thanks!
Hi Barritown,
Just following up, I've managed to figure out why the charts were not appearning (fixed it by editing the interactions of the slicers).
However, I noticed that the newly created and separate 'Country' tables aren't affected by slicers. May I know why this is? Thanks!