Minimum value from selected slicer options to be dispalyed in card

[evano_oruvan]

i have a slicer and card, now lets say if i select 2,3,4 from slicer the card should always display minimum selected value from slicer, if nothing is selected a default static text should be present.

thank you.

[v-yiruan-msft · Accepted solution]

Hi @evano_oruvan ,

According to your description, You want to display the maximum value when selecting multiple or single choices, display "all slicer selected" when selecting all, and display "fixed text" when there is no selection.Right?

Here are the steps you can follow：

(1)This is my test data:

(2)We can create a measure:  “Text”

Text =
IF (
    ISFILTERED ( 'Table'[CategoryName] ),
    IF (
        COUNTROWS ( VALUES ( 'Table'[CategoryName] ) )
            = COUNTROWS ( ALL ( 'Table'[CategoryName] ) ),
        "select all ",
        MIN ( 'Table'[CategoryName] )
    ),
    "no select"
)

Then we can put the [CategoryName] field in the slice visual and put the [Text] measure in the card to test.

(3)The results as follows:

[Note] We can't use the "select all" function of the slicer to determine whether to select all. Because the built-in "select all" function is the same as the logic of not selecting.

The ISFILTER() function cannot judge the following relationship:

If this method can’t  meet your needs, can you provide some special inputs and outputs so that we can help you better.

Best Regards

[v-yiruan-msft]

Hi @evano_oruvan ,

According to your description, You want to display the maximum value when selecting multiple or single choices, display "all slicer selected" when selecting all, and display "fixed text" when there is no selection.Right?

Here are the steps you can follow：

(1)This is my test data:

(2)We can create a measure:  “Text”

Text =
IF (
    ISFILTERED ( 'Table'[CategoryName] ),
    IF (
        COUNTROWS ( VALUES ( 'Table'[CategoryName] ) )
            = COUNTROWS ( ALL ( 'Table'[CategoryName] ) ),
        "select all ",
        MIN ( 'Table'[CategoryName] )
    ),
    "no select"
)

Then we can put the [CategoryName] field in the slice visual and put the [Text] measure in the card to test.

(3)The results as follows:

[Note] We can't use the "select all" function of the slicer to determine whether to select all. Because the built-in "select all" function is the same as the logic of not selecting.

The ISFILTER() function cannot judge the following relationship:

If this method can’t  meet your needs, can you provide some special inputs and outputs so that we can help you better.

Best Regards

[Chew_WenJie]

Hello, lets say your number 2,3,4 is ID, you can create a measure and put into the card for display the minimum selectedvalue.  

Measure = IF(NOT(ISFILTERED('Table'[ID])), 4, MIN('Table'[ID]))

The number 4 you can change to your default static text.

Hope this can help you.

[evano_oruvan]

thanks man, i just added max it worked any option i could add text so that if all slicer is selected it would display text as "all slicer selected".

[Chew_WenJie]

Hi, you can try below dax measure for the all slicer selected.

IF(DISTINCTCOUNT('Table'[ID])=8,"ALL SELECTED",IF(NOT(ISFILTERED('Table'[ID])),"4",MIN('Table'[ID])))

Hope this can help you.