Creative Ways to Express Sum (table/matrix visual

[stribor45]

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

[stribor45]

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?

[Irwan]

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.

[stribor45]

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:

1. create pie visual
2. Put card visual in the middle of it
3. Click on pie visual now as if you want to resize it
4. do you see visual from #2?

[Irwan]

hello @stribor45 

ah i see, as you said, it is happened because of matter of front and back like "send to front" or "send to back" in image arrangement in other MSO. It is happened because when you selected pie, the card was sent to back.

But this is only happened on Power BI Destop.

When you publish the report, the only visual that can be seen by user is the visual on the top of Selection panel (you might know this already, but i am sharing this just incase).

well, as you asked, if this can be fixed, i doubt no.

But you can make the visual is transparent so it will show the visual behind.

Re: How can I get a blank pie chart to show 0 is n... - Microsoft Fabric Community

see the solution provided by @v-jingzhan-msft

Hope this will help.

Thank you.

[stribor45]

When I publish it I can see the pie and card inside of it (behind it) but I can still click on the pie which makes card invisible so I am wondering if users can do the same they will get confused by this design. 

[Irwan]

Hello @stribor45 

If you can see it in published version either in workspace or in apps, users should be able to see it as well.

Thank you.

[stribor45]

Are you saying that if I have a visual #1 and i put visual #2 in the middle of #1 users will not be able to see visual #2 if they click on visual #1?

[Irwan]

hello @stribor45 

well if visual #1 is on top of visual #2 (placed above in selection panel), the user most likely will not able to see since it is hid behind visual #1 based on my previous project.

however, you can make that happens if you change visual #1 transparant in special condition so user will see visual #2.

But transparant color is one of many ways to do this. You can do with button-bookmark (maybe drillthrough should possible in your case as well)

Hope this will help.

Thank you.

[stribor45 · Accepted solution]

I was able to resolve this by grouping card and pie chart together

[Irwan]

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 value

4. 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.