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

0 votes
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?
May 20, 2019 in Power BI by Phalguni
• 1,020 points
230 views

1 answer to this question.

0 votes

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.

answered May 20, 2019 by avantika
• 1,500 points

Related Questions In Power BI

0 votes
1 answer
0 votes
1 answer

What options do I have for viewing and working with data on premises

There are three ways to achieve the ...READ MORE

answered Oct 15, 2018 in Power BI by Hannah
• 18,410 points
67 views
0 votes
1 answer

How do you add a slicer from different table in Power BI?

In order to add a slicer from ...READ MORE

answered Mar 5, 2019 in Power BI by Phalguni
• 1,020 points
450 views
0 votes
1 answer

How to add multiple reference lines on a bar/ column graph?

Hi, Follow below steps: 1. Add a bar/ column ...READ MORE

answered Mar 26, 2019 in Power BI by Cherukuri
• 32,490 points
2,917 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

How to get month name from month number in Power BI?

You can use: MonthName = FORMAT(DATE(1, [Num], 1), ...READ MORE

answered Sep 24 in Power BI by Alisha
39 views
0 votes
1 answer

How do I convert month format in Power BI?

Hi, This can easily be done using DAX ...READ MORE

answered Mar 26, 2019 in Power BI by avantika
• 1,500 points
2,977 views
0 votes
1 answer

How do I use Python scripts in Power BI?

Hi, You can create interactive reports out of ...READ MORE

answered May 2, 2019 in Power BI by avantika
• 1,500 points
1,314 views