Percent of Column Total - Stacked Bar Chart

[Anonymous]

Hello PBI Community,

I am having trouble displaying the % of column total (as opposed to % GT) in a stacked bar chart. I have done research and found what appears to be the correct measure, but it isn't working for me. Please see below. Any help is appreciated.

[v-shex-msft · Accepted solution]

HI @Anonymous,

You can try to use the following measure formula to calculate the total percent or current date category:

Meaure =
DIVIDE (
    CALCULATE (
        DISTINCTCOUNT ( Table[IOP Issue Source] ),
        ALLSELECTED ( Sheet1 ),
        VALUES ( Sheet1[Date] ),
        VALUES ( Sheet1[IOP Issue Source] )
    ),
    CALCULATE (
        DISTINCTCOUNT ( Table[IOP Issue Source] ),
        ALLSELECTED ( Sheet1 ),
        VALUES ( Sheet1[Date] )
    )
)

If above not help, can you please share some dummy data with a similar data structure to test? I can't access your sample, it required permissions to access.

Regards,

Xiaoxin Sheng

[Anonymous]

Step 1: Create a sum of your stacked components and add it as an additional data series (this will distort your graph initially)
Step 2: Right click the new data series and select “Change series Chart Type…”
Step 3: Choose one of the simple line charts as your new Chart Type.

[Anonymous]

Thank you for your reply, Lewis. I'm not totally following you though. I created a new measure that sums the total count I'm looking for. Where do I add that new measure in the bar chart?

[parry2k]

@Anonymous share the screen shot.

[Anonymous]

I continue to try and add the image and it won't show in the post. I can attach a pbix sample file, but do not see that option in the message pane either...

[parry2k]

@Anonymous you can share using one drive/google drive .

[Anonymous]

Can you view this link?

https://inspirewellness-my.sharepoint.com/:u:/g/personal/lbyrne1_humana_com/EQEfdvi_kYZEr14MYdJ4bd0B...