Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |