cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
UK_User123456
Resolver I
Resolver I

Additional Bar graph when selected

Hi All,

 

Below screenshot I have my bar graph which shows my sales over time for categories 1/2/3/4 and 6 are selected in my filter (Green bars). Is it possible to add in the red bar(s) when say categories 7 and 8 are selected and the red bar will appear? 

 

Capture.jpg

 

3 ACCEPTED SOLUTIONS
Vandalytic
Advocate II
Advocate II

Hi,

 

you can try to use a stacked column visual and customize the data colors for each category.

 

If you create a stacked column with categories in the legend and a Filter by Category you will hace something similar to:

StackedColumns.JPG

 

Then you can customize Data Colors in the Format Menu (first categories in green and categories 7 & 8 in red):

CustomizedDataColorsJPG.JPG 

 

Finally you will have this visual:

 

StackedColumnswithCustomizedDataColors.JPG

If you filter first categories, the columns appear in green color, but if you include 7 & 8 they will appear in red.

 

Other way is to create value groups in the Category field in order to assign each group a color:

 

https://docs.microsoft.com/en-us/power-bi/desktop-grouping-and-binning

 

Please, chek this answer as Solution if it solve your issue.

View solution in original post

Check the link : https://docs.microsoft.com/en-us/power-bi/desktop-grouping-and-binning

 

You can create a group for categories 7 & 8 and it works like a grouped value. Let's say you create a group for categories from 1 to 6 and call it "Green Categories" and another group for categories 7&8 called "Red Categories". Then you can add a slicer by Category Groups.

View solution in original post

Perfect! Thank you so much for your advice.

View solution in original post

6 REPLIES 6
Vandalytic
Advocate II
Advocate II

Hi,

 

you can try to use a stacked column visual and customize the data colors for each category.

 

If you create a stacked column with categories in the legend and a Filter by Category you will hace something similar to:

StackedColumns.JPG

 

Then you can customize Data Colors in the Format Menu (first categories in green and categories 7 & 8 in red):

CustomizedDataColorsJPG.JPG 

 

Finally you will have this visual:

 

StackedColumnswithCustomizedDataColors.JPG

If you filter first categories, the columns appear in green color, but if you include 7 & 8 they will appear in red.

 

Other way is to create value groups in the Category field in order to assign each group a color:

 

https://docs.microsoft.com/en-us/power-bi/desktop-grouping-and-binning

 

Please, chek this answer as Solution if it solve your issue.

Ok that may just work thank you, but what happens if I wanted to put a slicer in for the user to be able to say if they want to see Category 7/8?

Check the link : https://docs.microsoft.com/en-us/power-bi/desktop-grouping-and-binning

 

You can create a group for categories 7 & 8 and it works like a grouped value. Let's say you create a group for categories from 1 to 6 and call it "Green Categories" and another group for categories 7&8 called "Red Categories". Then you can add a slicer by Category Groups.

Perfect! Thank you so much for your advice.

TeigeGao
Solution Sage
Solution Sage

Hi @UK_User123456 ,

In your scenario, it is not possible to display the extra data on the visual by clicking the visual directly, as a workaround, we can create an extra slicer to select the visual you want to see.

Best REgards,

Teige

@TeigeGao many thanks for your response, how would the extra slicer work? I am open to different ways of getting around the issue I am having.

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors
Top Kudoed Authors