Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
sagarsahoo_123
Helper IV
Helper IV

Display multiple values with selectedvalue

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.

L4Name = "L4_DESC: " & FORMAT(SELECTEDVALUE(VW_NIPPON_PRODUCTIVITY[L4_DESC],"Multiple Selection"),"All")
 
I have used the L4_Desc in slicer, and it is coming fine upto single and more than one selection. But for non-selection, i am expecting to display "All" . It is not working for that. 
Please support in this regard.
 
sagarsahoo_123_0-1669438176196.png

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

1 ACCEPTED SOLUTION
TomMartens
Super User
Super User

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:
image.png

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

3 REPLIES 3
TomMartens
Super User
Super User

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:
image.png

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

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.

 
WIP =
CALCULATE (
    COUNT ( 'vwSupplier_Feedback'[_Identifier] ),
    FILTER(
        ALL ( 'vwSupplier_Feedback' ),
            [_PPG_Location] = SELECTEDVALUE('vwSupplier_Feedback'[_PPG_Location])
            && [_Issued_Date]<= SELECTEDVALUE ( 'Calendar'[Date] )
            && or( [_Resolved] >= SELECTEDVALUE ( 'Calendar'[Date].[Date] ) , [_Resolved] = BLANK() )      
            )
    )
 

 

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors