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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
GlassShark1
Helper III
Helper III

Adding a 'Greater than' slicer to something summarised as a measure

Say i have sales data, with rows by product, product type, the amount sold and then the year sold (e.g. row 1, product = Orange, Product Type = Fruit, Sold = 8, year = 2018, row 2, product Apple = 10, year 2018 etc).

I have a measure to calculate sales that looks something like SUM('Table'[Products Sold]), which responds to slicers like year and product type.

 

This is all fine, but i now want to have a slicer so the user can restrict their choices to only show products that have sold more than X amount. I cant use the measure as it seems you cant use this as a slicer.

 

Any ideas how you might implement this?

Thanks 🙂

1 ACCEPTED SOLUTION

@GlassShark1 

Check out this video from BI Elite: https://www.youtube.com/watch?v=AZAL-QPn5Zc

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

6 REPLIES 6
v-henryk-mstf
Community Support
Community Support

Hi @GlassShark1 ,

 

I think @Fowmy  basically solves your needs. For your further questions, whether you can provide detailed information or expected results, I will answer you as soon as possible.


Looking forward to your reply.

 

Best Regards,
Henry

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Fowmy
Super User
Super User

@GlassShark1 

You assign the measure "SUM('Table'[Products Sold])" to the slicer in the Filter Pane for this visual and set the amount you desire. Please check the below example for a different data set.


Fowmy_0-1620645973829.png

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Thanks @Fowmy, but unfortunately i can't use the filter pane in my organisation. Also, ideally i wanted to do with with a slicer, so it can sit with other slicers I need and the user can see everything being applied in one place. I would want them to start with their selections, then decide to filter them down to 'greater than X', rather than this logic being applied to the choices first, which i think may trip them up the way it's presented

@GlassShark1 

Check out this video from BI Elite: https://www.youtube.com/watch?v=AZAL-QPn5Zc

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Not had the chance to apply it yet, but pretty sure this gives me the answer. Thanks 🙂

Hi @GlassShark1 ,

 

If you think the problem has been solved, please consider Accept it as the solution to help the other members find it more quickly.😁


Best Regards,
Henry


Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.