Help creating bar graph that shows percent of given column value by month and also by hierarchy

[Antonio195754]

Hi all,

I've been basically trying to create what can be done with a Pivot table in Excel, into a bar graph in PBI. 

I've been able to match numbers when i create a matrix, screen shot below, but when i convert to a bar graph my %'s do not match.  I drop the values in the Late column where i'm looking to get % of "Not Late", and the only option i see is to change to "% of grand total", which is not the number i'm trying to get.  I'm trying to get the % of value total by months in one graph, and then by hierarchy in another graph using tier 3 column in sample data i've attached.

I'm attaching also the graphs i created that do not match

https://drive.google.com/file/d/1tulcsuSLafcmObyYo_A0Y5lcutKMedQA/view?usp=sharing

https://drive.google.com/file/d/17YJaXB7d-eTq6j0s6un2LMKsMRJXhYmw/view?usp=sharing

https://drive.google.com/file/d/1RRnxYNpdhQIzUmub2M9lVYxFy6Iarq5C/view?usp=sharing

[v-xicai · Accepted solution]

Hi @Antonio195754 , 

You may create measure like DAX below.

Measure1= DIVIDE(COUNT('Table'[Late]),CALCULATE(COUNT('Table'[Late]),ALL('Table')))

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-xicai · Accepted solution]

Hi  @Antonio195754 ,

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not,  let me know and I'll try to help you further.

Best regards

Amy

[v-xicai · Accepted solution]

Hi @Antonio195754 , 

You may create measure like DAX below.

Measure1= DIVIDE(COUNT('Table'[Late]),CALCULATE(COUNT('Table'[Late]),ALL('Table')))

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.