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 Team,
Request for your support to resolve the displaying issue with selected value. I have written the code for this. But for non-selection, it is not displaying message which i want.
Here my requirement is i want to display the elements based on Slicer selection.
If i am selecting one value from slicer, it will show the same, but for more than one selection, it will display "Multiple Selection" .
Upto this my code is working but i want to display "All" for no selection in slicer. It is not displaying "All".
Please find the code which i have written below.
If you look at the above image, here in the L4_Desc slicer there is no selection, but in the L4_DESC card below , it is showing " Multiple Selection" but i was expaecting "All" in that. But if i select more than one in the L4_Desc slicer, the message is coming correctly like "Multiple Selection"...
Please help to resolve this.
Regards,
Sagar
Solved! Go to Solution.
Hey @sagarsahoo_123 ,
you have to incorporate the DAX function ISFILTERED in your DAX statement: ISFILTERED – DAX Guide
Then your measure will look like this:
Measure =
IF( ISFILTERED( 'DimStore'[StoreName] )
, SELECTEDVALUE( 'DimStore'[StoreName] , "Multiple Selection" )
, "All"
)
The result - the bottom right card visual is the important one:
The top right card only contains a simple measure for illustrative purposes.
Hopefully, this provides an idea of how to tackle your challenge.
Regards,
Tom
Hey @sagarsahoo_123 ,
you have to incorporate the DAX function ISFILTERED in your DAX statement: ISFILTERED – DAX Guide
Then your measure will look like this:
Measure =
IF( ISFILTERED( 'DimStore'[StoreName] )
, SELECTEDVALUE( 'DimStore'[StoreName] , "Multiple Selection" )
, "All"
)
The result - the bottom right card visual is the important one:
The top right card only contains a simple measure for illustrative purposes.
Hopefully, this provides an idea of how to tackle your challenge.
Regards,
Tom
Hi All,
Let me refresh the topic. Just no to create new one.
I've got similar situation...
Formula counts Open Cases at each day in the past.
I have got a slicer so I can select a "_PPG_Location" to see Open Cases for the selected Location. The graph works perfectly with single location. But if I wanted to select multiple Locations, it is not working anymore.I think I understand why, but have no idea how to allow mulptiple selections.
I'll appreciate any help.
M
Hi @TomMartens ,
Thanks a lot for your quick support. It realy helped to resolve the issue.
Regards,
Sagar
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 |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |