Forum Discussion
Solved
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 ...
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:
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,
Nathan