Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Field Parameter - select none in slicer

Hi all, 

 

I'm using the field parameter preview function in one of my reports to select columns for a table. However, I would like the default of the slicer to be 'select none' if none of the fields is selected. By default it is 'select all'.

 

This might not be specific to field parameter slicers, but to slicers in general. Is there a way to achieve this?

 

Thanks!

Need Help
  • EdwardMoradian's avatar
    EdwardMoradian
    3 years ago

    What you can do with the new feature of Field Parameters (check in Preview features):

    1. Create a Column Called None with all blank values of ""
    2. Create a Field Parameter to select None field as well as the other fields you want (this lets you combine the fields together into 1 Slicer).
    3. Make Field Parameter into a Slicer.
    4. Now you will have a Slicer with None option that will give a blank result.  Select for this as the default to not show any results.  Save the dashboard in this state to keep the selection this way.  You can select the other fields to populate data.

     

7 Replies

  • EdwardMoradian's avatar
    EdwardMoradian
    New Member
    3 years ago

    What you can do with the new feature of Field Parameters (check in Preview features):

    1. Create a Column Called None with all blank values of ""
    2. Create a Field Parameter to select None field as well as the other fields you want (this lets you combine the fields together into 1 Slicer).
    3. Make Field Parameter into a Slicer.
    4. Now you will have a Slicer with None option that will give a blank result.  Select for this as the default to not show any results.  Save the dashboard in this state to keep the selection this way.  You can select the other fields to populate data.

     

    • Masthan's avatar
      Masthan
      Frequent Visitor
      2 years ago

      Hi EdwardMoradian  Thank you for your reply on this.
      Are there any other ways to handle this None column (hiding from table visual) because users point of view it is not ok to show them in the visual level.

       

      • hansei's avatar
        hansei
        Icon for Helper V rankHelper V
        2 years ago

        Instead of a blank column, or a measure with an empty value, use this hack courtesy of Barney Lawrence . Add a row to your table like this.

        Percentiles = {
    ("None", "Any non-empty string", 0),
    ("Network P0", NAMEOF('Table'[Measure]), 1)
}

        The column will not show up at all whether it is selected, or all are selected.

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    Anonymous , use a visual level filter

     

    measure = int(isfiltered('field parameter'))

     

    check above measure =1 in visual level filter

    • shuhaozh's avatar
      shuhaozh
      Regular Visitor
      7 months ago

      Thank you!! This should be selected as the best answer! A little bit translation here: first enable "select all" in slicer setting->selection, then manually un-check all the items in the slicer, finally disable the "select all".