Forum Discussion
Creative Ways to Express Sum (table/matrix visual
Is there a creative ways to express following idea. As an example say that we need to reach goal of $2000 worth of tickets. For each row in column amount to fill it with color until it reaches the goal. I know you can do conditinal formating but how would you incorporate total sum into it. so fopr example in my example you would have some color for $760, little less for $440 and so on but how to consider the total? Any other suggestion would be most welcome
| Ticket Type | Number of Tickets | Amount |
| Type A | 11 | $760 |
| Type B | 10 | $440 |
| Type C | 6 | $120 |
| Type D | 3 | $20 |
| Total | 30 | $1,340 |
I was able to resolve this by grouping card and pie chart together
10 Replies
hello stribor45
i might be wrong but if you are looking for conditional formating for auto total value in table visual, i doubt there is an option to do conditional formating.
i am not sure how your data looks like but if i have to create this, i would create Total value as row value.
1. Create calculate columns for 'Tickets' and 'Amounts'
Tickets =
IF(
'Table'[Ticket Type]="Total",
SUM('Table'[Number of Tickets]),
'Table'[Number of Tickets]
)Amounts =
IF(
'Table'[Ticket Type]="Total",
SUM('Table'[Amount]),
'Table'[Amount]
)2. create a measure for Total color and assign the color
Total Color =
IF(
SELECTEDVALUE('Table'[Ticket Type])="Total",
"Red"
)3. disable Total so it will not show Total value4. if needed, put rank in table visual as sort value so Total will always be in the bottom.
i am awared this is not perfect but this is one of many tricks.
Hope this will help.
Thank you.This is good suggestion but I decide to go another way. I found this tutorail on how to design KPI but after I finished it I noticed that when I click on pie chart the cards in the middle disaper. I feel like when i click on the pie it becomes active (takes over) and cards inside are therefore not visible. Is there a way to fix this?
hello stribor45
it quite hard to imagine what you are describing, but looks like it is happened as you mentioned.
other possibility if you have another table is your measure in card value is not connected to pie chart so when pie is selected, there is no value on card.
here is a simple example based on your sample data above. i am not sure if this matched to your desired result, but your sample data above should have no issue on creating pie and card.
Hope this will help.
Thank you.
I am not saying that value disapered I am saying that visual card is not visible as pie chats its put in forefront. As it is brought to the front and therefore other visual in middle is not visible any more. Try this:
- create pie visual
- Put card visual in the middle of it
- Click on pie visual now as if you want to resize it
- do you see visual from #2?
