David on 17 Jun 2020 06:14:50
To be able to select a demographic point in a slicer that updates the category in the x-axis of graph, or the category in a table. For example, gender, age category, race group can be toggled in a slicer, and they will in turn update the category in a graph or table. This will help in making a dashboard page more efficient. There is a solution I saw using index and unpivot, but the values are distorted by category when other slicer/filters are selected.