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.
Hi,
I'd like to see within a card a comment based on selection of the slicer.
I'm not sure how go about this.
This is the slicer:
If "Selected All" or none selected then "All".
If all 0-7 in green selected then "Sub".
If only 220 selected then "High".
If there are random selections then "Multiple".
This will be for a title of a chart. I'm working with selectedvalue but with no success so far. Still going at it.
I likely was not clear with the card expectations.
@amitchandak
@Anonymous
Here's a better example:
Slicer settings:
if none selected. Card reads "none".
if all selected. Card reads "All".
if all selected as shown. Meaning all of 0-1-2-3-4-5-6-7 are selected at the same time. Card reads "Sub".
if only "220" is selected as shown. Card reads "High".
Thanks for the attemped solutions, but none of them met the criteria or did something entirely different than intended.
I tried to play around and modify the solutions but still could not get them to work.
Still seeking help please.
@Anonymous
I commented out the line for "Multiple". I still do not know what [ct] mean. Until that is clear, I can leave that out.
As you can see, even when nothing is selected "All" does show up in the card.
Along the same lines, selecting 0-7, "Sub" does not show either on the card.
I'll play with your expression to see if I can get it to go.
Thanks for the response.
Any further help is appreciated!
Hi,
this should do the trick:
@Anonymous
Hi Max,
I do not know what [ct] means with respect to the expression. I do not have a column "ct" in my table.
Should I use an use an explicit measure to get count? Does ct = count?
Thanks.
Ron
Switch(
isblank( Selectedvalue(Table[Column])) , "All",
Selectedvalue(Table[Column]) *1 <=7, "Sub"
Selectedvalue(Table[Column]) *1 =220, "High"
//add other conditions
)
@amitchandak
Thank You for the reply.
Maybe there is somethings I am missing as it is not working for me. I created the measure and
dropped it into a card and choose the slicer settings but get the following....
Not sure what I am doing wrong.
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |