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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Need help

Hi All,

 

I have a requirement to display the Project Name and Client Name  as per the selected project in the slicer.

Example: in the page i have only one project name slicer  and two card,one for the project name and one for  the clinet name .So  when ever the person slected project name in the slicer  the slected project name needs to be disply in the project name card and with respected client name for the project needs to be displyed in the Client Name Card

 

for the project name displying i am using the below dax

SELECTEDVALUE('Table'[Project Name])
and for the client name i dont have any slicer in the page but those two columns are dependent (coming from the same table)
when the project is not selected in the slicer in the cards it needs to  be display All the project in the project name card and all the clients in the client name card
Can some one please help me on this 
 
Thanks
Nagaraju.g
1 ACCEPTED SOLUTION

Hi @Anonymous ,

 

Please try the following measure:

 

 

project name meaure =
IF (
    ISFILTERED ( 'Table'[Project Name] ),
    SELECTEDVALUE ( 'Table'[Project Name] ),
    "All the project"
)

Client name meaure =
IF (
    ISFILTERED ( 'Table'[Project Name] ),
    CALCULATE (
        MAX ( 'Table'[Project Name] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[Project Name] = SELECTEDVALUE ( 'Table'[Project Name] )
        )
    ),
    "All the client"
)

 

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

View solution in original post

4 REPLIES 4
amitchandak
Super User
Super User

@Anonymous , Not very clear.

 

Try like

 

max('Table'[Client Name])
or
concatenatex(Table,'Table'[Client Name])

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
manikumar34
Solution Sage
Solution Sage

@Anonymous ,

 

Check with the below DAX.

 

SWITCH(TRUE(),SELECTEDVALUE('Table'[Project Name]),Distinct('Table'[Client Name]),"No value selected Slicer ")

 

On card we can pass only single value. So whenver nothing is slected on slicre you can show "No value selected Slicer "

 

If you find this is helpful Please Accept as a Solution and leave a like.

 

Regards, 

Manikumar

 

 





If this helps, Appreciate your KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




Anonymous
Not applicable

Hi Mani kumar,

 

Thanks for the quick replay

 

but the given dax is not giving the results,it showing the below error.

 

 

 

 

 

Thanks!!

NagarajuCapture.PNG

 

Hi @Anonymous ,

 

Please try the following measure:

 

 

project name meaure =
IF (
    ISFILTERED ( 'Table'[Project Name] ),
    SELECTEDVALUE ( 'Table'[Project Name] ),
    "All the project"
)

Client name meaure =
IF (
    ISFILTERED ( 'Table'[Project Name] ),
    CALCULATE (
        MAX ( 'Table'[Project Name] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[Project Name] = SELECTEDVALUE ( 'Table'[Project Name] )
        )
    ),
    "All the client"
)

 

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!