I have a data table that contains
Date (MMDDYY), Work Order#, Product, Qty of Parts Placed, Defects Qty, and a calculated colum titled PPM which is ((Defect Qty / Placed Qty)*1000000)
However, when I create a bar chart to visual show the PPM value for each Product and Work order, I cannot display the PPM value as Product, it wants to show it as an aggregate...
I like to use slicers in the visual to select a specific product and/or date range and then see the corresponding PPM performance by Work Order#s.
I'm failry new to Power BI and any help/guidence would be greatly appreciated!