Can we show specific values from table visual on card

[abhijit_vetal]

Hello Community,

I am bit new to power BI.

I have created table as shown below which also contains measures and slicer on Activity period/year

I can't fetch M_result directly on card or another table visual as it's also dependent on fiscal year/period

So my requirement is to display the result on card as effective or ineffective based on M_result value. If abs(M_result)>10% then it would be Effective otherwise Ineffective.

Can we fetch those values from table visual?

Please help me to solve the problem I am stuck here!!

Thanks in advance!!

Extract specific rows from table based on dynamic slicer selection  for reference

[V-lianl-msft]

Hi @abhijit_vetal ,

If you want to extract certain specific values, in the visual level filter of card visual, give it a context filter with specific values.

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

[amitchandak]

@abhijit_vetal , seem like M_result  is using some row context because that grand total is not there. Because of the total is not there it will not work on card visual

https://www.youtube.com/watch?v=ufHOOLdi_jk

[abhijit_vetal]

But can we extract those values regardless of total and grand total.I want to extract value.