Forum Discussion

AvijitD_05's avatar
AvijitD_05
New Member
2 years ago
Solved

Show Text Dynamically Based on Filter Selection

Hello,

 

I am using a slicer in my report and I want show show the Text "Multiple", if more than one values are selected in the slicer.

 

For example, the Slicer has 4 values: Red, Blue, Black and Green. If I select only one colour it should come up on a card visual but I make more than colour selections let's say both Red and Green, then the card should show "Multiple".

 

Could you please help me with the DAX code, I should write for this problem?

 

Concatenatex is not what I am looking for as I am not trying to stack on additional values. 

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi AvijitD_05 

     

    Thanks for the reply from BeaBF and Shaurya .

     

    AvijitD_05 , you can try the following measure.

    Measure = 
VAR _count = CALCULATE(COUNT('Table'[Color]), FILTER('Table', [Color] IN VALUES('Table'[Color])))
RETURN
IF(_count = 1, MAX([Color]), "Multiple")

     

    Output:

     

     

    Best Regards,
    Yulia Xu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • BeaBF's avatar
    BeaBF
    Super User
    2 years ago

    AvijitD_05 Hi!

     

    Create these two measures and use the second in the card:

    SelectedCount =
    IF(
        HASONEVALUE('ColorsTable'[Colors]),
        1,
        COUNTROWS(VALUES('ColorsTable'[Colors]))
    )
     
    SelectedValueOrMultiple =
    IF (
        [SelectedCount] = 1,
        VALUES('ColorsTable'[Colors]),
        "Multiple"
    )
     
    if it's ok, please mark the message as a solution
     
    BBF



  • Shaurya's avatar
    Shaurya
    Memorable Member
    2 years ago

    Hi AvijitD_05,

     

    How about you count the selected values first:

     

    SelectedColorCount = 
IF(
    ISFILTERED(YourTable[ColorColumn]),
    COUNTROWS(VALUES(YourTable[ColorColumn])),
    0
)

     

    And then use:

     

    SelectedColorDisplay = 
IF(
    [SelectedColorCount] = 0,
    "None Selected",
    IF(
        [SelectedColorCount] = 1,
        FIRSTNONBLANK(YourTable[ColorColumn], "None"),
        "Multiple"
    )
)

     

    Mark this post as a solution if that works for you!
    Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI  

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi AvijitD_05 

     

    Thanks for the reply from BeaBF and Shaurya .

     

    AvijitD_05 , you can try the following measure.

    Measure = 
VAR _count = CALCULATE(COUNT('Table'[Color]), FILTER('Table', [Color] IN VALUES('Table'[Color])))
RETURN
IF(_count = 1, MAX([Color]), "Multiple")

     

    Output:

     

     

    Best Regards,
    Yulia Xu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.