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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors