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...
Need Help
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)
      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi vik0810,

         

        10.17% is the one of data column 2. How I want to call below in my statement.

         

        [source for 10.17%]