Forum Discussion

jfenico's avatar
jfenico
Helper III
8 years ago
Solved

Filtering out multiple data from columns when using a slicer

Slicers are a great way to let our users find specific info for there projects. However, the dashboard we have includes all information from all projects until they actively select one from the slice...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

You can try this:

 

measure =
IF (
    HASONEVALUE ( table[slicer column] ),
    [measure you want to display],
    BLANK ()
)
  • jfenico's avatar
    jfenico
    Helper III
    8 years ago

    Hi Chris,

    Thanks for the quick response. Little confused (or uninitiated), what should I be popping into the [measure you want to display] section? 

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      I don't believe there's a way yet to simply hide a table based on too much being selected.

       

      The measure I gave you would go on your table visual IN PLACE OF the pre-existing measure.  Let's say you have an example measure called [Sales].  Your new measure would reference [Sales] where I wrote 

       

      [measure you want to display]

      That way the measure will show a blank until the slicer has a selected value, and then your measure will calculate [Sales] as normal