Slicer that filters the y-axis of a chart

[Anonymous]

Hi all,

I'm trying to make a simple stacked column chart that has, e.g, Name on the X axis and Count of Name in the Y-Axis.

What I want to do is add a slicer that filters the chart for Count of Name so I can filter to only show the Names repetead 5 times for example (or any number). I tried to add a Count of Name measure to a Slicer but AFAIK it doesn't take measures. I tried to use dynamic parameters but I hit a roadblock.

It is possible to filter by Count of Name using the Filters Pane on the chart but I'd prefer a slicer so users can slice and see counted/repeated names as they please, for example, they may want to see only names repeated more than 55 times.

Thank you.

[Anonymous · Accepted solution]

Hi @Anonymous ,

Try creating an unconnected table and a slicer with visual filters for column charts.

Please review the attached PBIX file.

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 in the Power BI Forum

[CoreyP]

Use What-If Parameters.