Forum Discussion

ppgandhi11's avatar
ppgandhi11
Icon for Helper V rankHelper V
8 years ago
Solved

How to display filter values on same page as filter itself?

Hi,

 

I have about 5 filters on page1. each of them is a long list. There is a visual on the lower half. Every time user has to scroll through each of the filters to see which ones are selected. Is there any way that I can display the selected filter values on the same page along with visual? This would make it much easier for users to see which filters are used and with what values instead of scrolling each of them.

 

Thanks.

  • Hi ppgandhi11

     

    You can create a calculated measure similar to the following and just drag it to a Card Visual on your report canvas.  It will display the currently selected value from the table[column] from your slicer.

     

    Measure = SELECTEDVALUE('Table 2'[Column]) 

6 Replies

  • Phil_Seamark's avatar
    Phil_Seamark
    Icon for Microsoft Employee rankMicrosoft Employee

    Hi ppgandhi11

     

    You can create a calculated measure similar to the following and just drag it to a Card Visual on your report canvas.  It will display the currently selected value from the table[column] from your slicer.

     

    Measure = SELECTEDVALUE('Table 2'[Column]) 
    • Anonymous's avatar
      Anonymous
      Not applicable

      Phil_Seamark if we select multiple values then how can we do it?

       Using  SELECTEDVALUE(table[column],"All") ,  it will show 'All' even for multiple values.  How can we make it work for three scenarios
      single select, multiple values , All?
      • Anonymous's avatar
        Anonymous
        Not applicable


        This is the method I've used. The measure below will return nothing ("") if the 'Products'[Type] field isn't filtered. If that column has been filtered and there are more than 5 rows selected then it returns "Multiple". Otherwise, I use CONCATENATEX to grab all the values selected and use a comma and space to seperate each value of 'Products'[Type]. Before the CONCATENATEX I have some other text that will concatenate some user friendly text. If a user selects 2 Products[Type] values the whole measure will return "| Type - Type Selection 1, Type Selection 2". So I then repeat this measure for each column in the table that might have a filter selected by the user.
        Selected Type =
        IF (
        ISFILTERED ( 'Products'[Type] ),
        IF (
            COUNTROWS ( VALUES ('Products'[Type] ) ) >=5,
            "Multiple",
            " | Type - "&
                CONCATENATEX ( VALUES ( 'Products'[Type]), 'Products'[Type], ", " )

                 )
            ),
            ""
            )
        )
        Then I add a measure that concatenates all the selection measures and put them in a visualization that supports text, like a card. The final measure might look like [Selections] = [Selected Type]&[Selected Sub Type]. I don't have worry about separating text because those are in the selection measures. Result example: "| Type - Type 1 | Sub Type - Sub Type 1, Sub Type 2".

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar

    Hi ppgandhi11,

     

    For another option, if you only select one value for each Slicer, you could select the Dropdown type of Slicer which should meet your requirement.

     

    If you only select one value it will show the value you selected. If you select mutiple values, it will show Multiple selections.

     

     

     

    Hope this also can help you!

     

    Best Regards,

    Cherry