Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Filtering with 100% Stacked Bar Chart

Hello, 

Need some urgent assistance on this one, please! 

I have 2 charts,

1. A pie chart showing color distribution which looks like below, 

 

2. A 100% Stacked Bar Chart with the same distribution based on different segments. 


What I want:
I want the bar chart to totally filter itself based on the colour selection I make in the pie chart.

Example-
When I click on the Green slice in the Pie chart, in the 2nd Bar chart, I intend to see only green bars with their respective values ( 34.04%,48.81%,73.91% etc..) and the rest of the colours to be filtered out of the chart.
I know there's an option "Edit Interactions" which enables Highlighting but that's not what I want. Instead, I want the visual to filter itself so that the selected colour takes up the entire bar chart and shows the correct values based on their respective segments.

I tried adding a colour slicer but the problem is when I select a particular colour, all the values get distributed to 100% because I believe the denominator is affected, 


FYI - These charts are currently based on columns and not measures. 
 
I would really love your help with this, I've been trying to crack this for a long time!🙏

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    It's a bit difficult if you are using 100% stacked bars chart. Because it is always guaranteed that the final result of each bar is 100% (which would lose a lot of information).

     

    We can make slight changes to the stacked bar chart so that it becomes a 100% stacked bar chart, and with cross-filtering, we can successfully achieve our goal.

    The PBIX file is attached for reference:

     

    Best Regards,
    Gao

    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    It's a bit difficult if you are using 100% stacked bars chart. Because it is always guaranteed that the final result of each bar is 100% (which would lose a lot of information).

     

    We can make slight changes to the stacked bar chart so that it becomes a 100% stacked bar chart, and with cross-filtering, we can successfully achieve our goal.

    The PBIX file is attached for reference:

     

    Best Regards,
    Gao

    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data

  • Hi Anonymous ,

     

    Sorry, I don't understand what you want because you don't want highlighting. Can you draw it out?

     

    Best regards.