Anglais428v2
New Member
- Joined
- Jun 19, 2020
- Messages
- 27
- Office Version
- 365
- Platform
- Windows
Hi,
I have a Slicer with 3 fields: Year, Country and Indicator. The user can move the year toggle bar, select one or multiple countries and/or one or multiple datapoints.
I have a table output which works fine. However, for my chart output it is too clustered if multiple data points are chosen (with different unit scales). Therefore, is there a way to produce multiple charts if multiple selections are made?
E.g.
I choose 2 countries (A and B) and two Indicators (C and D) for years 2000-2010. I would like the table to include the all data related to this (I can do this part). However, I would like one chart showing countries A and B for years 2000-2010 for Indicator C. And then a separate chart for countries A and B for years 2000-2010 for Indicator D. I feel like this might be possible through a measure/Dax. E.g. If multiple indicators are chosen put the first selection in Chart 1 and the 2nd selection in Chart 2.
Any ideas?
Thanks
I have a Slicer with 3 fields: Year, Country and Indicator. The user can move the year toggle bar, select one or multiple countries and/or one or multiple datapoints.
I have a table output which works fine. However, for my chart output it is too clustered if multiple data points are chosen (with different unit scales). Therefore, is there a way to produce multiple charts if multiple selections are made?
E.g.
I choose 2 countries (A and B) and two Indicators (C and D) for years 2000-2010. I would like the table to include the all data related to this (I can do this part). However, I would like one chart showing countries A and B for years 2000-2010 for Indicator C. And then a separate chart for countries A and B for years 2000-2010 for Indicator D. I feel like this might be possible through a measure/Dax. E.g. If multiple indicators are chosen put the first selection in Chart 1 and the 2nd selection in Chart 2.
Any ideas?
Thanks
