Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
Solved! Go to 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
@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
Proud to be a Super User!
Hi Mani kumar,
Thanks for the quick replay
but the given dax is not giving the results,it showing the below error.
Thanks!!
Nagaraju
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