How do I label bar graph with different colors based on values from different slicers

Question

Hi,

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?

Answer 1

If the user selects only one value from the 1st slicer, 2nd slicer will also have only one option which will the same value as the 1st slicer. After this, you can change the color of the visualizations and the charts by the editing option mentioned just below the visualization panel.