Forum Discussion
Add slicer option as dynamic filter to line graph
- 1 year ago
Hey v-saisrao-msft
thanks for the pbix. That really looks good for my solution. I slightly changed a bit the line graph and it works fine for me.
1 & 2. I changed the "Servicename" filter to the one from Table "ServiceDepartmentMap" so that the used filter for the group is working (it than shows only the services that are relevant for this group and only 1 value (instead of 24)). Also I selected the service that is valid for this specific line graph. In the chart (in 6) the other service for group a is shown (I also added this to the titel so that it is automaticly switched witht the group).
3. Group filter is than valid selection for the line graphs and they are switched by selecting the groups
4. I changed the values for x / y axle and legend to have the time graph for every year in the line graph
5. in the line graph now the correct single value is displayed for every single data point (no more average over many service / mixing up the values)
6. service name is also dynamic based on selection per line graph.
Perfect solution! Thank you all very much for your help!