Skip to main content
cancel
Showing results for
Search instead for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper III

## SWITCH AND SEVERAL VALUES to display in a card

I would like to know How is it possible to diplsay a value with a card when this one is selected in a filter?

I tried with the formula "Selectedvalue" but first, if nothing is selected then the value displays "(Vide)" whereas i would like to display something else in text. Second point, if we select 2 values, is is possible to display those ones?

Here is my exemple :

SWITCH(SELECTEDVALUE(Temps[Trimestre affichage]),"Trim 1","Trimestre 1","Trim 2","Trimestre 2","Trim 3","Trimestre 3","Trim 4","Trimestre 4","")

Several selection :

How can we do if we have several value ? Because here I have just 4 values but if i have more?

In add, if I select 2 values, it doesn't work (it displays nothing)

I don't know how is it possible to mix all that.

Thank you in advance for your return.

Léna

1 ACCEPTED SOLUTION
Super User

Hello Lena,
Kindly follow my instruction

create a new measure

``````Semester Filtered =
IF(
ISFILTERED('Table'[Semester]),
VAR _f = FILTERS('Table'[Semester])
VAR _d = CONCATENATEX(_f, SUBSTITUTE('Table'[Semester],"Trim","Trimester") ," , ")
RETURN
_d
,"Vide")``````

hope this helps if it does, a kudos and accept the solution would be appreciated

4 REPLIES 4
Helper III

Hi @eliasayyy , thank you for your explanations, it's very clear.

However, I have an other request to add in this formula. How can we add an other filter, for exemple, in drill down we can have "month".

So, if i select Trimester 1 then it displays Trimester 1 in the card. But if i select january then, it displays January and delete the Trimestre value in the card.

I played with the formula in different case but in vain.

Thank you a lot  in advance and have a good day !

Léna

Super User

hmmm can you please show me an example

Helper III

Hi @eliasayyy ,

Sorry for being late,

Of course I can , here I select trimester + month :

But, If I do this, it shows in he card this result :

The best result it's if we can display only the month. On the contrary, if I select all trimester, then it displays "Trimester 1" if not "January" (or January & February). Etc.

I hope i am clear 🙂

Thank you in advance,

Léna

Super User

Hello Lena,
Kindly follow my instruction

create a new measure

``````Semester Filtered =
IF(
ISFILTERED('Table'[Semester]),
VAR _f = FILTERS('Table'[Semester])
VAR _d = CONCATENATEX(_f, SUBSTITUTE('Table'[Semester],"Trim","Trimester") ," , ")
RETURN
_d
,"Vide")``````

hope this helps if it does, a kudos and accept the solution would be appreciated

## Helpful resources

Announcements

#### Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors