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

Make slicer show relevant options

Imagine I have a table that has phone calls. And for each call done there is an agent linked to it. I created a table that contains all the possible agents and with that I made a slicer that will allow me to see the calls an agent has done by having a measure that counts them and a visual that shows it. Now I want to make the slicer only show the agent "options" that are relevant. For example, imagine I filter my page by date (forgot to say that each of my calls contained a date) and so the measure that counts phone calls changed accordingly and everything, but there are agents which really contribute nothing to the total, and that if I filter by them I will see they have 0 calls, is there any way to be able to make it so that the slicer doesn't show agents with no phones linked to them?

I know it's a little abstract and everything so if I haven't been able to explain myself I will try to create a new pbix so that it's more visual but for now let's see if someone can get it without it.

I'm trying to get what this guy shows in the first part of this page but what he does doesn't seem to work for me:

https://www.kasperonbi.com/showing-only-slicer-data-that-have-facts-in-power-bi-and-other-fun-tricks...

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper I
Helper I

I'm such a retard, this is the solution I just didn't take into account a filtering problem I had, so if anyone wants to do the same as me go to:

https://www.kasperonbi.com/showing-only-slicer-data-that-have-facts-in-power-bi-and-other-fun-tricks...

View solution in original post

1 REPLY 1
Highlighted
Helper I
Helper I

I'm such a retard, this is the solution I just didn't take into account a filtering problem I had, so if anyone wants to do the same as me go to:

https://www.kasperonbi.com/showing-only-slicer-data-that-have-facts-in-power-bi-and-other-fun-tricks...

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors