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.
Hello everyone,
I have some supply chain data where i have the total number of shippments. among those we only have data for 2 categories, not shipped and delivered. The end user also wants a pie chart with percentages including a 3rd catgory called Not scheduled.
Our data only contains shippments that are delivered and not shipped since we have tracking numbers and info about it.
Example if there are 400 orders in total, and our data sheet has 150 shipped, 200 not delivered only then the remaining 50 is not scheduled. How do I represent this as a pie chart?
Your help is appreciated. Thank you.
Hi @Anonymous ,
Can you give your sample data and expected results? Does your category column have only two categories, not shipped and delivered? So how does your total number 400 appear in the data, because the not shipped and delivered data add up to only 150+200=350.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , You have to create three measure and show them in pie visual without any legends
Hi,
Since "Not Scheduled" label itself is not there in your data, You can create 3 measures (Not Shipped, Delivered & Not Scheduled) and drag them into the
Values section of "Pie Chart".
Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂
Regards,
N V Durga Prasad
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |