Forum Discussion

ktaylorBHS's avatar
ktaylorBHS
New Member
9 years ago

Sum Cards with dynamic value

We are trying to sum up different cards with dynamic values and cannot figure out how to do so. We are wanting to be able to select different percentages for each category and it sum the totals on th...
Need Help
ktaylorBHS's avatar
ktaylorBHS
New Member
9 years ago

I am wanting to add all the cards on the left. For example, I could select 30% on the first card, 20% on the second, etc and then be able to sum them all up and the number be dynamic that way if I wanted to change the percentage on the first one, it would change the total. Does that make sense? Not sure if that is even a possibility. Thank you for the help! 

MFelix's avatar
MFelix
Super User
9 years ago

How are you getting the values on the cards? Is it a measure or do calculate it directly from a column in your data?

 

Mfelix

  • ktaylorBHS's avatar
    ktaylorBHS
    New Member
    9 years ago

    It is from a column on an Excel spreadsheet. 

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Microsoft Employee
      9 years ago

      Hi ktaylorBHS,

      Whta's the visual you used? 

      >>For example, I could select 30% on the first card, 20% on the second, etc and then be able to sum them all up and the number be dynamic that way if I wanted to change the percentage on the first one, it would change the total.

      If we create slicer visual, we can filter the table by clicking special value on it. For your requirement, how to select the 30% on the first, 20% on the second? Do you mind share your .pbix file for further analysis?

      Thanks,
      Angelia