Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to 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.
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
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
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.
User | Count |
---|---|
131 | |
74 | |
70 | |
58 | |
53 |
User | Count |
---|---|
190 | |
97 | |
67 | |
62 | |
54 |