Question: Now its your turn to create a Pareto chart. Create a Pareto chart visualizing the count of Order ID by Sub-Categories. Apply a filter to

Now its your turn to create a Pareto chart. Create a Pareto chart visualizing the count of Order ID by Sub-Categories. Apply a filter to the visualization to specifically select for Office Supplies. 1. In a new Power BI report, connect to the Orders table in the Global Superstore dataset. 2. Add a clustered column and line combination chart. 3. Filter the combination chart to only include Office Supplies. 4. Add Sub-Category to the X-Axis and COUNT(Order ID) to the column y-Axis. 5. Sort the chart descending by the COUNT(Order ID). 6. Add a new measure to the orders table, Cumulative %. 7. Refer to the sample code above to write the Cumulative % DAX calculation. 8. Change the format of the Cumulative % calculated measure to %, with 0 decimal places. 9. Add the Cumulative % calculated measure to the Line y-axis. 10. Add data labels on the Cumulative % calculated measure.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!