Filter and show the Data in card

[Sriku]

Hi,

I am trying to achieve this requirement but not able to 

On selection on any stages in the visual it should display in the card. For example, If I select Stage1 ----->c, the Card value should show C, If I select Stage3---->D, then it should show D.

Stage1	Stage2	Stage3
A
B	A
C	C	D
D	D	A
E	B	B

[Anonymous]

Hi @Sriku ,
Has the issue been resolved on your end? If so, please share your solution and mark it as "Accept as Solution." This will assist others in the community who are dealing with similar problems and help them find a solution more quickly.
Thank you.

[Anonymous]

Hi @Sriku ,
I wanted to check in on your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply that helped you or sharing your solution. It would be greatly appreciated by others in the community who may have the same question.
Thank you.

[Anonymous]

Hi @Sriku ,
Thank you @ryan_mayu and @lbendlin for the prompt response!

Could you please confirm if the issue has been resolvedon your end? If a solution has been found, it would be greatly appreciated if you could share your insights with the community .This would be helpful for other members who may encounter similar issues.
Thank you for your understanding and assistance.

Regards,
Pallavi.

[ryan_mayu · Accepted solution]

@Sriku 

you can try this

Measure =

 if(ISFILTERED('Table'[Stage3]) &&DISTINCTCOUNT('Table'[Stage3])=1, max('Table'[Stage3]), if(ISFILTERED('Table'[Stage2])&&DISTINCTCOUNT('Table'[Stage2])=1, max('Table'[Stage2]), if(DISTINCTCOUNT('Table'[Stage1])=1, max('Table'[Stage1]),blank())))

[lbendlin]

Please describe what you mean by "select".

[Sriku]

@lbendlin  , 

If I select Stage1 column as selected column ----->C, the Card value should show "C," If I select Stage3 Column as selected column---->D, then it should show "D".

[lbendlin]

What do you mean by "select" ?  How do you select a column?

[Sriku]

@lbendlin , Select here means select a value from graph

[lbendlin]

By clicking on the value? Do you use cross filtering or cross highlighting?