Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dynamic Title based on multiple slicer values to return "No Filters Applied" when no values selected

I have multiple measures for SELECTEDVALUE to show what filters are being applied in a pop-out slicer (pop out slicer has 10 filters).  My SELECTEDVALUE measures are combined, and I use a / separator...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

    I have created a simple sample, please refer to my pbix file to see if it helps you.

    Create a measure based on the measures.

    Measure_result =
IF (
    NOT ( ISBLANK ( [Measure] ) && ISBLANK ( [Measure 2] ) ),
    COMBINEVALUES ( "/", [Measure], [Measure 2] ),
    "No Filters Applied"
)

    If I have misunderstood your meaning, please provide your desired output with more details and your pbix file without privacy information.

     

    Best Regards

    Community Support Team _ Polly

     

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

     

     

eleftheriaK's avatar
eleftheriaK
New Member
3 years ago

Hi!

If your slicers are single select then SELECTEDVALUE is ok. 
For avoiding the /// appearing when no selection have been made you can use this:
VAR _a =
IF(
      SELECTEDVALUE(TableA[Column1])<>BLANK(),
      SELECTEDVALUE(TableA[Column1])&"/",BLANK()
)
VAR _b = 
IF(
      SELECTEDVALUE(TableB[Column1])<>BLANK() && _a<>BLANK(),
      "/"&SELECTEDVALUE(TableB[Column1]),
      IF(SELECTEDVALUE(TableB[Column1])<>BLANK() && ISBLANK(_a),
      SELECTEDVALUE(TableB[Column1]),
      BLANK()
)
)
.

.

.

VAR Title = IF (ISBLANK(_a) && ISBLANK(_b) &&..... , "No Filters Applied", _a&_b&....)

RETURN

Title