Forum Discussion
Query for Pie Chart
Dear all,
I am quite new to Power BI. Currently, I am facing beginners issue. The following I'd like to do in Power BI which I have done previously in Excel.
Data:
Reported Event Order Status
1 VEA123 Reported
2 VEA123
3 VEA124 Reported
4 VEA124 Reported
5 VEA125
Result in a pie chart
3 orders = 100%
Reported = 66% (Reported for 2 out of 3 orders)
Not reported = 33% (only 1 order without any report)
How do I set up such a case in Power BI
Steffen
stevoboy -
A couple notes:
1. The script is for a DAX calculated column. You are in Power Query.
a. It is also possible to perform this task in Power Query:
-Make a copy of your query
-In the new query, Group By Order to get Max of Status per order.
-In the original query, Merge with the new query.
-Expand the table to retrieve the Max Status.
2. The script assumes your table is called Order Reported. You can substitute that text with the name of your table.
3. How to add a DAX calculated column:
3 Replies
Hi stevoboy -
Add this calculated column to your table, and then use it as the Legend in the Pie chart.
Order Reported Status =Calculate(max('Order Reported'[Status]),ALLEXCEPT('Order Reported','Order Reported'[Order]))Hope this helps,NathanThanks for your help. I put in your script, I get an error though. What am I doing wrong?
stevoboy -
A couple notes:
1. The script is for a DAX calculated column. You are in Power Query.
a. It is also possible to perform this task in Power Query:
-Make a copy of your query
-In the new query, Group By Order to get Max of Status per order.
-In the original query, Merge with the new query.
-Expand the table to retrieve the Max Status.
2. The script assumes your table is called Order Reported. You can substitute that text with the name of your table.
3. How to add a DAX calculated column:
