Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
chrisrenfrew
New Member

Slider / Card for Count of Users who have Submitted a X+ ticket

I am trying to analyze the results of a service desk and have a single table with the following columns:

 

Ticket Number

User Name

 

I currently have a PBI report that displays each user name and a distinct count of their submitted tickets.

 

I would like to create a visual (using the CARD or Matrix visual) that shows the number of users who have submitted a particular count of tickets (or higher).  Ideally, this would use a slider so that I could set the minimum of the slider to 5 (and let the maximum be whatever the maximum count is).  The result of this visual is that I can get an accurate count of the number of professionals who have submitted X+ of tickets.

 

Thanks!

1 REPLY 1
Greg_Deckler
Community Champion
Community Champion

Well, you could use a filter and set it to greater than some number. But that wouldn't give you the slider interactivity. I suppose you could create a slicer and then a measure that compared the distinct count of each user to the MAX of that value.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.