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 21, 2019 in Power BI by Phalguni
• 1,020 points
1,454 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 21, 2019 by Avantika
• 1,520 points

Related Questions In Power BI

0 votes
1 answer

How do I count rows in one table based on values in another table using DAX?

If the tables are related, this is ...READ MORE

answered Sep 24, 2020 in Power BI by Gitika
• 65,890 points
22,556 views
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,540 points
653 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
1,546 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
• 33,030 points
8,706 views
0 votes
1 answer
0 votes
1 answer

Using DAX calculation how to calculate monthly budget till today in power bi Desktop?

You can make use of this: MTD Budget ...READ MORE

answered Sep 24, 2020 in Power BI by Gitika
• 65,890 points
1,812 views
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, 2020 in Power BI by Alisha
6,226 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 27, 2019 in Power BI by Avantika
• 1,520 points
4,947 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,520 points
2,397 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP