Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I have three cards, each showing a different total (for the number of clients who have received different services). The cards correspond to the categories in a slicer, and the slicer has to be multi-select. My client wants to the cards to show a 0 if the slicer value is not selected and the corresponding total if the value is selected.
I had a version of this that worked, but only because I set the slicer to single-select. When I change the slicer to multi-select and select more than 1 option, the cards all show 0.
Here's an example for one of the three cards that works with a single-select slicer but not with the multi-select slicer that I need.
Is it possible to achieve what my client wants?
Solved! Go to Solution.
Hi @Anonymous ,
According to your statement, I think your issue should be caused by "All" in SELECTEDVALUE().
The logic of SELECTEDVALUE('aec_surveys Participants'[service_type], "All") is when you selected multiple values or not select value it will return "All".
Here I suggest you to try code as below to achieve your goal.
demo_total_training_consulting =
VAR _service_type_selector =
VALUES ( 'aec_surveysParticipants'[service_type] )
RETURN
IF(
ISFILTERED('aec_surveys Participants'[service_type]),
IF(
"Training & Consulting" in _service_type_selector,
[service_total_training_consulting]),0),
0
)
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for your help, @Anonymous ! I was re-using some code without really thinking through what it meant.
I was successful using a portion of your suggestion:
Hi @Anonymous ,
According to your statement, I think your issue should be caused by "All" in SELECTEDVALUE().
The logic of SELECTEDVALUE('aec_surveys Participants'[service_type], "All") is when you selected multiple values or not select value it will return "All".
Here I suggest you to try code as below to achieve your goal.
demo_total_training_consulting =
VAR _service_type_selector =
VALUES ( 'aec_surveysParticipants'[service_type] )
RETURN
IF(
ISFILTERED('aec_surveys Participants'[service_type]),
IF(
"Training & Consulting" in _service_type_selector,
[service_total_training_consulting]),0),
0
)
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
75 | |
54 | |
38 | |
31 |
User | Count |
---|---|
99 | |
56 | |
50 | |
42 | |
40 |