topic Re: I want to label bar graph with different colors based on values from different slicers in DAX Commands and Tips

I want to label bar graph with different colors based on values from different slicers

Anonymous — Mon, 13 May 2019 21:07:32 GMT

Hi,

I have two issues:

1. I want to create two slicers from same column. If I create a calculated column of the original column, I can use the values in two different slicers. But I want to achieve that the visible values in the second slicer will be the selected values of the first slicer. Then I want to select only one value from that slicer.

2. Now there will be two groups: One will multiple values and the other with single vlaue. Now 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, remaining selections from first slicer in another color.

Any ideas or help would be appreciated.

Thank you.

Re: I want to label bar graph with different colors based on values from different slicers

parry2k — Sat, 18 May 2019 03:51:08 GMT

Anonymous what if user select only one value from 1st slicer, 2nd slicer will also have onlu one option which will the same value as 1st slicer, what woudl be the logic for the color than.

Re: I want to label bar graph with different colors based on values from different slicers

parry2k — Sat, 18 May 2019 03:51:32 GMT

Anonymous also Please share data in excel using onedrive/google drive to get your answer quickly. Remove any sensitive information before sharing.