Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
hvora787
New Member

Desglose a sub-catagorías para el gráfico de columnas agrupadas

Buenos días

Estoy tratando de crear un informe para analizar datos de chatarra en mi planta de fabricación. Me gusta comenzar a un alto nivel y ser capaz de explorar en profundidad para problemas específicos. A continuación se muestra un ejemplo de los datos.

La fabricación se divide en diferentes departamentos. La impresión sería una de ellas. Ese departamento definirá chatarra en términos de categorías como Dirt, Scratches, Color, etc. Todo eso se agregará a una chatarra de departamento general para impresión. Esto se hace para todos los departamentos.

Me gustaría tener un gráfico visual de gráfico de columnas agrupadas que muestra los totales de chatarra para cada departamento. Así que tendría una columna para Imprimir chatarra. Me gustaría hacer clic en eso y ser capaz de profundizar en las subcategorías de suciedad, arañazos y color para ver el desglose.

Si esto no es posible, tener otro gráfico de columnas agrupadas en la misma página que muestre las subcategorías respectivas cuando se hace clic en la columna de rechazo del departamento también funcionaría.

Gracias por el tiempo y el apoyo de todos de antemano.

FechaOrden de trabajoLoteImpresión de chatarra (total)SuciedadArañazosColor
1/1/202012318125
1/2/2020123214554
1/2/2020567118837
1/3/2020567216826

5 REPLIES 5
v-juanli-msft
Community Support
Community Support

Hola @hvora787

¿Este problema es amado?

Si es amado, ¿podría aceptarlo amablemente como una solución para cerrar este caso y ayudar a los otros miembros a encontrarlo más rápidamente?

Si no, por favor no dude en ha decirmelo.

Saludos

Maggie

v-juanli-msft
Community Support
Community Support

Hola @hvora787

¿La tabla muestra la estructura de sus datos reales?

Si no, ¿podría mostrar más información?

Saludos

Maggie

Hola Maggie,

He pegado algunos de los datos a continuación. No estoy familiarizado con la interfase para esta placa y no pude encontrar una manera de adjuntar el archivo de Excel real. Por favor, hágamelo saber si esto funciona para usted.

R, N, I, C, M y P Los rechazos son chatarra de diferentes departamentos. R R1, R R2 y así sucesivamente en el lado derecho de la tabla son subcategoríaes de rechazos de cada departamento. Por favor, ignore la fila superior. Cuando se elimina el formato HTML, las celdas superiores no se descomponen.

Por favor, hágamelo saber si tiene alguna pregunta. Gracias por su ayuda.

saludos

Hemal

Detalle del pedidoDepartamentosRendimientoDEPARTAMENTO SUB-CATAGORIES
Número de trabajoOrden de trabajoLoteFechaR RechazosN RechazosRechazoC RechazosM RechazosP RechazosbienMuestras de control de calidadTotal MaloTamaño de loteRendimiento% de chatarraR R1R R2N R1N R2I R1I R2I R3C R1C R2M R1M R2P R1P R2
1182319136006821/2977061111382211650076%23%54522444215110110
1182319136006831/246441091440928950082%18%135116325552759
1182319136006851/2959732011351214750070%29%54414428252181283
1182319136006891/244311019941927950084%16%312223265512772
1182319136007171/237754920378212050076%24%214331291531361010
1216519141525401/2895541215393210550079%21%4445131233110296
1216519141525441/23545551640588750081%17%213217919141497
1216519141525671/21081134196336216250067%32%55534050232210924
1216519141525741/2671179811338216050068%32%2425503730452638
1216519141525851/22665311840129750080%19%1151201530122953
1216519141525861/277337202140129750080%19%345213911529111011
1216519141525911/2661027129354214450071%29%4224393627528454
1216519141525941/26736541642227650084%15%51343285143197
1216519141525951/265100673369212950074%26%154125048423421
1216519141525971/2108736148377212150075%24%55533017261512235

Hola @hvora787

Si desea mostrar subcategoría en categoría al profundizar, consulte mi consulta a continuación:

Capture12.JPGCapture13.JPG

Tabla2

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("jZVLjhsxDETv0oB3E0AU9b1CrjDwIhfI/ZexSiyJbliYLNTd1vexRJa/vy+RFvX6uqSLlhBeX6XF1zP++v3n7+vdX62OhqExUfjQORE/x0jG8loeo1fHM79asjfmJutIWGUj2DDsj+fXZyx1WMloUuLiASrYO3Q7rvVF1eLgkfawY9SfXawjZuslb7XvfmTKN6kwu3K/sKTKQqlS3VIFSNW9VMmgEFhspKJeo0OifegRq9+kGk23zt1ok1Cq6qRKEAnXqHZsdA2RFaeUUKqKGZ+ZqlTHpFzBsDvl0toYLn6/JRXIKEWyfRBXxPVnh6yWITNiy6ooJU+sJHlslFNwWI23SCyENrftyrND3ly4uygPpzMTXhabOizgRDunHKnSTSwA+fRE0iagDOq2s6qBRqrXarFXOxkXTxX5nrV+QCr+/hAFclGUm3QTXLXwtBIXVQGPRuY6G5bPi6ZUy1VY1hFHHLiql6pYXskKdEICayVW2YlV2saKFkkk3szH8QjXu5HRMdqJ6s0YuKKs/GQpp8Dq6u4CYQvS6VXeJ6elZDL52qT96JGpOCbWq7IUsXOU/4HilS9jUmaVuN7VIWaDB6wutwucVUtTEe6lmZcjKA+rQNkeynFepGIZoq4OrDn8Y1r1T2mlZS1jBUYeWPdfoDloZq6zAulYsHUOsFOuHwqw5xsRxkPwfGBkyUjcpl6ndRbm1ArC5iLXE5WhzS/Bj0wfTaEu703Wo7UuKNlQebv63RNmemNVcczi/4Xy9Xz+Aw==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Job Number" = _t, #"Work Order" = _t, Batch = _t, Date = _t, #"R Rejects" = _t, #"N Rejects" = _t, #"I Rejects" = _t, #"C Rejects" = _t, #"M Rejects" = _t, #"P Rejects" = _t, Good = _t, #"QC Samples" = _t, #"Total Bad" = _t, #"Batch Size" = _t, Yield = _t, #"Scrap %" = _t, #"R R1" = _t, #"R R2" = _t, #"N R1" = _t, #"N R2" = _t, #"I R1" = _t, #"I R2" = _t, #"I R3" = _t, #"C R1" = _t, #"C R2" = _t, #"M R1" = _t, #"M R2" = _t, #"P R1" = _t, #"P R2" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Job Number", Int64.Type}, {"Work Order", Int64.Type}, {"Batch", Int64.Type}, {"Date", type date}, {"R Rejects", Int64.Type}, {"N Rejects", Int64.Type}, {"I Rejects", Int64.Type}, {"C Rejects", Int64.Type}, {"M Rejects", Int64.Type}, {"P Rejects", Int64.Type}, {"Good", Int64.Type}, {"QC Samples", Int64.Type}, {"Total Bad", Int64.Type}, {"Batch Size", Int64.Type}, {"Yield", Percentage.Type}, {"Scrap %", Percentage.Type}, {"R R1", Int64.Type}, {"R R2", Int64.Type}, {"N R1", Int64.Type}, {"N R2", Int64.Type}, {"I R1", Int64.Type}, {"I R2", Int64.Type}, {"I R3", Int64.Type}, {"C R1", Int64.Type}, {"C R2", Int64.Type}, {"M R1", Int64.Type}, {"M R2", Int64.Type}, {"P R1", Int64.Type}, {"P R2", Int64.Type}}),
    #"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"R Rejects", "N Rejects", "I Rejects", "C Rejects", "M Rejects", "P Rejects"}),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Removed Columns", {"Job Number", "Work Order", "Batch", "Date", "Good", "QC Samples", "Total Bad", "Batch Size", "Yield", "Scrap %"}, "Attribute", "Value"),
    #"Split Column by Delimiter" = Table.SplitColumn(#"Unpivoted Columns", "Attribute", Splitter.SplitTextByEachDelimiter({" "}, QuoteStyle.Csv, false), {"Attribute.1", "Attribute.2"}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Attribute.1", type text}, {"Attribute.2", type text}}),
    #"Renamed Columns" = Table.RenameColumns(#"Changed Type1",{{"Attribute.1", "Rejects"}, {"Attribute.2", "sub_Rejects"}, {"Value", "sub_Rejects value"}}),
    #"Merged Queries" = Table.NestedJoin(#"Renamed Columns", {"Job Number", "Work Order", "Batch", "Date", "Good", "QC Samples", "Total Bad", "Batch Size", "Yield", "Scrap %", "Rejects"}, #"Table 2 (2)", {"Job Number", "Work Order", "Batch", "Date", "Good", "QC Samples", "Total Bad", "Batch Size", "Yield", "Scrap %", "Rejects"}, "Table 2 (2)", JoinKind.FullOuter),
    #"Expanded Table 2 (2)" = Table.ExpandTableColumn(#"Merged Queries", "Table 2 (2)", {"Rejects value"}, {"Table 2 (2).Rejects value"})
in
    #"Expanded Table 2 (2)"

Tabla 2(2)

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("jZVLjhsxDETv0oB3E0AU9b1CrjDwIhfI/ZexSiyJbliYLNTd1vexRJa/vy+RFvX6uqSLlhBeX6XF1zP++v3n7+vdX62OhqExUfjQORE/x0jG8loeo1fHM79asjfmJutIWGUj2DDsj+fXZyx1WMloUuLiASrYO3Q7rvVF1eLgkfawY9SfXawjZuslb7XvfmTKN6kwu3K/sKTKQqlS3VIFSNW9VMmgEFhspKJeo0OifegRq9+kGk23zt1ok1Cq6qRKEAnXqHZsdA2RFaeUUKqKGZ+ZqlTHpFzBsDvl0toYLn6/JRXIKEWyfRBXxPVnh6yWITNiy6ooJU+sJHlslFNwWI23SCyENrftyrND3ly4uygPpzMTXhabOizgRDunHKnSTSwA+fRE0iagDOq2s6qBRqrXarFXOxkXTxX5nrV+QCr+/hAFclGUm3QTXLXwtBIXVQGPRuY6G5bPi6ZUy1VY1hFHHLiql6pYXskKdEICayVW2YlV2saKFkkk3szH8QjXu5HRMdqJ6s0YuKKs/GQpp8Dq6u4CYQvS6VXeJ6elZDL52qT96JGpOCbWq7IUsXOU/4HilS9jUmaVuN7VIWaDB6wutwucVUtTEe6lmZcjKA+rQNkeynFepGIZoq4OrDn8Y1r1T2mlZS1jBUYeWPdfoDloZq6zAulYsHUOsFOuHwqw5xsRxkPwfGBkyUjcpl6ndRbm1ArC5iLXE5WhzS/Bj0wfTaEu703Wo7UuKNlQebv63RNmemNVcczi/4Xy9Xz+Aw==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Job Number" = _t, #"Work Order" = _t, Batch = _t, Date = _t, #"R Rejects" = _t, #"N Rejects" = _t, #"I Rejects" = _t, #"C Rejects" = _t, #"M Rejects" = _t, #"P Rejects" = _t, Good = _t, #"QC Samples" = _t, #"Total Bad" = _t, #"Batch Size" = _t, Yield = _t, #"Scrap %" = _t, #"R R1" = _t, #"R R2" = _t, #"N R1" = _t, #"N R2" = _t, #"I R1" = _t, #"I R2" = _t, #"I R3" = _t, #"C R1" = _t, #"C R2" = _t, #"M R1" = _t, #"M R2" = _t, #"P R1" = _t, #"P R2" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Job Number", Int64.Type}, {"Work Order", Int64.Type}, {"Batch", Int64.Type}, {"Date", type date}, {"R Rejects", Int64.Type}, {"N Rejects", Int64.Type}, {"I Rejects", Int64.Type}, {"C Rejects", Int64.Type}, {"M Rejects", Int64.Type}, {"P Rejects", Int64.Type}, {"Good", Int64.Type}, {"QC Samples", Int64.Type}, {"Total Bad", Int64.Type}, {"Batch Size", Int64.Type}, {"Yield", Percentage.Type}, {"Scrap %", Percentage.Type}, {"R R1", Int64.Type}, {"R R2", Int64.Type}, {"N R1", Int64.Type}, {"N R2", Int64.Type}, {"I R1", Int64.Type}, {"I R2", Int64.Type}, {"I R3", Int64.Type}, {"C R1", Int64.Type}, {"C R2", Int64.Type}, {"M R1", Int64.Type}, {"M R2", Int64.Type}, {"P R1", Int64.Type}, {"P R2", Int64.Type}}),
    #"Removed Other Columns" = Table.SelectColumns(#"Changed Type",{"Job Number", "Work Order", "Batch", "Date", "R Rejects", "N Rejects", "I Rejects", "C Rejects", "M Rejects", "P Rejects", "Good", "QC Samples", "Total Bad", "Batch Size", "Yield", "Scrap %"}),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Removed Other Columns", {"Job Number", "Work Order", "Batch", "Date", "Good", "QC Samples", "Total Bad", "Batch Size", "Yield", "Scrap %"}, "Attribute", "Value"),
    #"Extracted Text Before Delimiter" = Table.TransformColumns(#"Unpivoted Columns", {{"Attribute", each Text.BeforeDelimiter(_, " "), type text}}),
    #"Renamed Columns" = Table.RenameColumns(#"Extracted Text Before Delimiter",{{"Attribute", "Rejects"}, {"Value", "Rejects value"}}),
    #"Sorted Rows" = Table.Sort(#"Renamed Columns",{{"Rejects", Order.Ascending}})
in
    #"Sorted Rows"

Saludos
Maggie
Equipo de apoyo a la comunidad _ Maggie Li
Si este post ayuda, entonces considera Aceptarlo como la solución para ayudar a los otros miembros a encontrarlo más rápidamente.

Hola Maggie,

Gracias por proporcionar la respuesta detallada. Esto es de gran ayuda.

saludos

Hemal

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors