Stacked Column Chart Filtering Other Visuals

Data Visualizations
1

Hello all!
I have a column visual that needs to filter the other visuals by the legend rather than the axis when clicking on a column. Is this possible? The axis is assessment scores grouped and the ledgend is the subject column from the same table. Ideally, they want to be able to click on a bar representing a group member and filter a matrix consisting of a list of students by the subject.

image
image750×411 8.83 KB

image
image902×364 22.9 KB

Will share more detail if this is a modelling or DAX issue but first I wanted to find out if it was possible at all.

Thanks everyone!

2

Hi @mkaess. I think a work-in-progress PBIX with a marked-up screen shot of what you are getting and what you’re looking for would be of great help to the forum members in reviewing your issue.
Greg

3

Thanks for the reply. I’ll get something up in the next few days.

4

Hello @mkaess, it’s been a while since we got a response from you.

If you do, kindly provide the information the experts requested above (PBIX File) so they can help you further.

Here are some videos that may help you masking sensitive data and create datasets and data models representative of your problem:

In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

5

I’ve put together a redacted version of the model in a pbix file with the following in a text box within the report.

When clicking on a column in the graph, it is currently filtering by Normalised Mark (groups) then by Subject (the legend of the visual) and recalculating the average. The users basically want to use the graph as a Subject Code slicer rather than the drop down slicer.
Stacked Column Visual Example.pbix (718.9 KB)

What it needs happen when clicking on a column or section of the column, is to apply the filter or Subject Code (legend) only as if the slicer is being used.

6

If you add turn on the legend on your top chart, you can click the Subject Code in the legend itself to slice the data by it - if I’m understanding what you’re needing correctly!

7

I was trying to avoid showing the Legend but doing so fixes the issue. Thanks!