Don't miss your chance to take exam DP-600 or DP-700 on us!
Request nowLearn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
I have an excel spreadsheet which essentially has 5 different options for people to choose from. Once selected they can input numbers in the following column.
There is then a formula that gives the total of all of these options. This has been set up as a card visual in my dashboard.
Is there a way to create a card so that instead of having the total of all 5 options. I can create multiple cards with each options total?
| User | Count |
|---|---|
| 50 | |
| 40 | |
| 32 | |
| 14 | |
| 13 |
| User | Count |
|---|---|
| 87 | |
| 73 | |
| 37 | |
| 28 | |
| 26 |