Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filter selection with "Select All"

Hi Team,   I have a report to be shown with the following  1.   when user opens the report, the table visual should show empty or blank  2.   when user selects the "Select All" from the filter, i...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi Anonymous ,

     

    "Select all" in filter pane and slicer doesnt have any filtering function,it just shows a result of all the selections selected.

    I have a workaround for you:

    Create a table as below:

    Slicer table = UNION(VALUES('Table'[column1]),ROW("column1","Select all"))

    Then create a measure as below:

    Measure = IF(ISFILTERED('Slicer table'[column1]),
IF(SELECTEDVALUE('Slicer table'[column1])="Select all",
CALCULATE(MAX('Table'[column1]),'Table'[column1] in VALUES('Table'[column1])),
CALCULATE(MAX('Table'[column1]),'Table'[column1] in FILTERS('Slicer table'[column1]))))

    And you will see:

     

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    amitchandak Thanks Amit, I already have this measure in place like

     

    Message = if(isfiltered(table[column]),"", "select a value")

    Make Transparent = if(isfiltered(table[column]), "#FFFFFF00","White")

     

    These measures are working as intended. 

     

    But my question is I need the user to see a blank table when he logs into the report and then click on "select all"  from filter to see all rows or select indiviual item in the filter to view that particular item. 

     

     

    • v-kelly-msft's avatar
      v-kelly-msft
      Icon for Community Support rankCommunity Support
      5 years ago

      Hi Anonymous ,

       

      "Select all" in filter pane and slicer doesnt have any filtering function,it just shows a result of all the selections selected.

      I have a workaround for you:

      Create a table as below:

      Slicer table = UNION(VALUES('Table'[column1]),ROW("column1","Select all"))

      Then create a measure as below:

      Measure = IF(ISFILTERED('Slicer table'[column1]),
IF(SELECTEDVALUE('Slicer table'[column1])="Select all",
CALCULATE(MAX('Table'[column1]),'Table'[column1] in VALUES('Table'[column1])),
CALCULATE(MAX('Table'[column1]),'Table'[column1] in FILTERS('Slicer table'[column1]))))

      And you will see:

       

      For the related .pbix file,pls see attached.

       

      Best Regards,
      Kelly

      Did I answer your question? Mark my post as a solution!