Following are the issues I am facing
1. I wanted to create two slicers from the same column. But If I create a calculated column from the original column, I can use the values in two different slicers. In case I want that the visible values in the second slicer will be the selected values of the first slicer, then I need to select only one value from that slicer.
2. There are two groups: One with multiple values and the other with single values. From this data I want to create a stacked column chart for all the selected values and color it in two groups - single selection from second slicer in one color, the remaining selections from first slicer in another color.
How do I do this?