Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

How to filter the value data on card

Hi,

 

I want to show the data on CARD custom visual but I dont want its show the sum value of data if not select specific data using slicer.

 

Below is the data for column 1 and column2 

I want on the card custom visual show the data overall 10.17% not the sum of the column 2 data but at the same time it interactive with the the slicer custom visual.

 

 

Example:

1. Card shows data when not click the slicer

2. When I click WPC05 on slicer it will show data for WPC05

Need Help

15 Replies

  • BeemsC's avatar
    BeemsC
    Icon for Resolver III rankResolver III
    8 years ago

    Hey,

    If i understand correctly, you want to stop 1 visual interacting with another one.
    This can be aquired by using 'edit interactions', in the Format tab

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi BeemsC,

       

      Thanks for your help but I dont want to stop the interaction. I want its interact with the slicer but I dont want the card custom visual show the sum of the data when we dont use the slicer. I want its show one of the data 10.17%. I think its will have DAX statement but I did not get it.

       

      • vik0810's avatar
        vik0810
        Icon for Resolver V rankResolver V
        8 years ago

        HI Anonymous, where does 10,17% come from?

         

        Generally you can use functions HASONEVALUE and VALUES for your measure, something like that:

         

        Measure = IF(HASONEVALUE(Table[WPC]), VALUES(Table[Percentage]), [source for 10.17%])

         If 10.17% is constant value then

         

        Measure = IF(HASONEVALUE(Table[WPC]), VALUES(Table[Percentage]), 0.1017)