Forum Discussion
Stacked Bar Chart Responds To Selection Inconsistently
I'm using a stacked bar chart next to a table. The bar chart when every name is selected looks like this:
However when I start selecting names from the table, the bar chart responds differently and I can't figure out why.
This is what it looks like for some names which I don't really like.
This is what it looks like for other names:
The data is the same in both the table and the chart. How can I get this to respond the same for every name in the table?
Hi Basil_Flash ,
I believe that the question is the interactions between visualizations try to change the way the table interacts with the chart:
5 Replies
Can you provide more information:
What do the colors mean - is it some category column in the same table as whatever number is being displayed? How many tables are involved, are you using dimension tables and fact tables, if so what is in those tables, what is the Y axis here (measure- if so what is the measure, or summed column?) how are the tables connected, if they are, etc.
///Mediocre Power BI Advice, but it's free///
Hi Basil_Flash ,
I believe that the question is the interactions between visualizations try to change the way the table interacts with the chart:
That is perfect. So much to learn, but the challenge is finding answers sometimes.
The chart represents sales by month stacked by industry for this year and last year. The table is the name of the sales person with a column for last year sales and a column for this year sales. When I select a sales person, I only want to see their sales by month and industry in the chart. Some sales people have sales in every industry and some do not, but that doesn't seem to be the reason for the two different responses by the chart.
If I use a filter by sales person, the chart responds correctly, but I would like for the users to be able to select the name in the table and see the chart respond correctly.
Alright, so I believe what you want to do is modify the way your visuals interact.
Select the Table, go to Format, and click Edit interactions.
Then, select the Table. Above the graph you posted a screenshot of, you'll see three options. One is for NO interaction, one is for Highlight (this is what you currently have selected), and lastly Filter. You want "Filter".
///Mediocre Power BI advice, but it's free///
