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 an...
  • 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.

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