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 am creating a visual card that interacts with a slicer, whereby if a user selects one option from the slicer the option will display in a separate visual card. If a user does not select an option the visual card will display "No option selected". Finally, if a user selects multiple options from the slicer the visual card will display the selected options concantenated or if over 3 options are selected the card shall return: "Multiple options selected"
Note: All slicer options come from the same column within the table (Region).
Currently I have got this:
Solved! Go to Solution.
Hi,
Here is one way to do this kind of state checking:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
Proud to be a Super User!
Hi,
Here is one way to do this kind of state checking:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
Proud to be a Super User!
Hi,
Appreciate your response and it has helped very much.
Currently I can handle whether multiple regions or one single region/s are selected, but when no regions are selected the card returns the "multiple regions" strings.
This is the dax:
Testing =
Hi,
The last part of SWITCH argument is [else] like this:
SWITCH(<expression>, <value>, <result>[, <value>, <result>]…[, <else>])
Because of this you don't need the counter = 1 part of the dax since If a slicer doesn't have one or multiple values its state is logically no filters. This way we can use the else part of SWITCH.
Proud to be a Super User!
Hi,
I need your help,
I have a situation here where I need to show multiple values selected from multiple sicers in a card visual.
multiple values of same slicer should be seperated by ","and multiple values from multiple slicers should be seperated by "|".
when no values selected from any of the slicers , it should show "Not Selected"
for example, if I select 2017 and 2018 from Year slicer,
result is : 2017,2018 (here "|" is not expecting after the result)
if I select HYD and BZA from LocID slicer and 2021,2022 from year slicer and Azure-C,Azure-F from CourseID,
result is: HYD,BZA | 2021,2022 |Azure-C,Azure-F
If I select no values from three slicers,
Result is: Not Selected
Thanks in advance...
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 |
---|---|
46 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
51 | |
45 | |
15 | |
12 |