Single value less than slicer

[Anonymous]

I have some large values in a dataset that I would like to filter out in order to see what the data looks like without those outliers.

I see that the less than slicer gives you an input box, or a slider. I just want to click a button and see all visuals only show values less than 10,000. It's either all, or <10,000 every time.

Thank you!

[mwegener · Accepted solution]

Hi @Anonymous ,

maybe with a bookmark?

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[Anonymous]

Thank you for the idea! This works for the most part, however a bookmark resets all filters back to the point in time where the bookmark was created. Idealy I would like to have it where the <10000 filter can be applied anywhere and does not reset other attributes. Any ideas there?

[mwegener]

Hi @Anonymous ,

a calculated column to slice the data?

Column = IF('Table'[Value] < 1000, "less 1000", "greater 1000")

If I answer you question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[mwegener]

Hi @Anonymous ,

try this out.

PBIX

If I answer you question, please mark my post as solution, this will also help others.

Please give Kudos for support.