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 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 , Not very clear.
Try like
max('Table'[Client Name])
or
concatenatex(Table,'Table'[Client Name])
@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
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |