Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |