Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Single value less than slicer

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!

Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    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.

4 Replies

  • mwegener's avatar
    mwegener
    Most Valuable Professional
    6 years ago

    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.

    • mwegener's avatar
      mwegener
      Most Valuable Professional
      6 years ago

      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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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's avatar
        mwegener
        Most Valuable Professional
        6 years ago

        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.