March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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 :
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
Solved! Go to Solution.
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
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
hmmm can you please show me an example
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
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
25 | |
18 | |
15 | |
9 | |
8 |
User | Count |
---|---|
37 | |
32 | |
16 | |
16 | |
12 |