Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
User | Count |
---|---|
25 | |
11 | |
8 | |
7 | |
7 |
User | Count |
---|---|
24 | |
13 | |
12 | |
10 | |
6 |