topic Re: Minimum value from selected slicer options to be dispalyed in card in DAX Commands and Tips

Minimum value from selected slicer options to be dispalyed in card

evano_oruvan — Sat, 27 Aug 2022 02:20:08 GMT

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.

Re: Minimum value from selected slicer options to be dispalyed in card

Chew_WenJie — Sat, 27 Aug 2022 04:03:48 GMT

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.

Re: Minimum value from selected slicer options to be dispalyed in card

evano_oruvan — Sat, 27 Aug 2022 11:42:57 GMT

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".

Re: Minimum value from selected slicer options to be dispalyed in card

Chew_WenJie — Mon, 29 Aug 2022 00:24:12 GMT

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.

Re: Minimum value from selected slicer options to be dispalyed in card

Anonymous — Tue, 30 Aug 2022 08:42:06 GMT

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

Re: Minimum value from selected slicer options to be dispalyed in card

Anonymous — Tue, 30 Aug 2022 08:43:01 GMT

Hi evano_oruvan ,

Here are the steps you can follow：

(1)This is my test data:

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

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