Forum Discussion
Solved
si Condition Color
Hola a todos en este Power Bi projet intentamos calcular el número de estado Ri dependiendo de la condición A,B,C (para fijar el color). El formato De Las Medidas es Color_Format_1 =
...
Hola @POWER_MI ,
Trate de rehacer la mesa de la siguiente manera
TypeLevelValue
A A1 R1, R2, R31 A A2 R2, R32 A A3 R21 B B1 R1 B B2 R2, R22, R31, R21 B B3 R32 C B1 R1 C B2 R22 C B3 R2, R32, R31, R21 Ahora cambie sus medidas a:
Calculation = SWITCH ( TRUE (); SELECTEDVALUE( 'Table'[Level] ) = "A1"; CALCULATE([Measure1]; COLOR_FIELD_TO_ADD[Coulumn] IN { "R1"; "R2"; "R31" }); SELECTEDVALUE( 'Table'[Level] ) = "A2"; CALCULATE([Measure1]; COLOR_FIELD_TO_ADD[Coulumn] IN { "R22"; "R32" }); SELECTEDVALUE( 'Table'[Level] ) = "A3"; CALCULATE([Measure1]; COLOR_FIELD_TO_ADD[Coulumn] IN { "R21" }); SELECTEDVALUE( 'Table'[Level] ) = "B1"; CALCULATE([Measure1]; COLOR_FIELD_TO_ADD[Coulumn] IN { "R1"}); SELECTEDVALUE( 'Table'[Level] ) = "B2"; CALCULATE([Measure1]; COLOR_FIELD_TO_ADD[Coulumn] IN { "R2"; "R22"; "R31"; "R21" }); SELECTEDVALUE( 'Table'[Level] ) = "B3"; CALCULATE([Measure1]; COLOR_FIELD_TO_ADD[Coulumn] IN { "R32" }); SELECTEDVALUE( 'Table'[Level] ) = "C1"; CALCULATE([Measure1]; COLOR_FIELD_TO_ADD[Coulumn] IN { "R1" }); SELECTEDVALUE( 'Table'[Level] ) = "C2"; CALCULATE([Measure1]; COLOR_FIELD_TO_ADD[Coulumn] IN { "R22" }); SELECTEDVALUE( 'Table'[Level] ) = "C3"; CALCULATE([Measure1]; COLOR_FIELD_TO_ADD[Coulumn] IN { "R2"; "R32"; "R31"; "R21" }) ) Formatting = SWITCH ( TRUE (); SELECTEDVALUE( 'Table'[Level] ) = "A1"; "Red"; SELECTEDVALUE( 'Table'[Level] ) = "A2"; "Green"; SELECTEDVALUE( 'Table'[Level] ) = "A3"; "Pink"; SELECTEDVALUE( 'Table'[Level] ) = "B1"; "Red"; SELECTEDVALUE( 'Table'[Level] ) = "B2"; "Green"; SELECTEDVALUE( 'Table'[Level] ) = "B3"; "Pink"; SELECTEDVALUE( 'Table'[Level] ) = "C1"; "Red"; SELECTEDVALUE( 'Table'[Level] ) = "C2"; "Green"; SELECTEDVALUE( 'Table'[Level] ) = "C3"; "Pink" )Consulte la conexión de resultados.
Hola @POWER_MI ,
Trate de rehacer la mesa de la siguiente manera
TypeLevelValue
| A | A1 | R1, R2, R31 |
| A | A2 | R2, R32 |
| A | A3 | R21 |
| B | B1 | R1 |
| B | B2 | R2, R22, R31, R21 |
| B | B3 | R32 |
| C | B1 | R1 |
| C | B2 | R22 |
| C | B3 | R2, R32, R31, R21 |
Ahora cambie sus medidas a:
Calculation =
SWITCH (
TRUE ();
SELECTEDVALUE( 'Table'[Level] ) = "A1"; CALCULATE([Measure1]; COLOR_FIELD_TO_ADD[Coulumn] IN { "R1"; "R2"; "R31" });
SELECTEDVALUE( 'Table'[Level] ) = "A2"; CALCULATE([Measure1]; COLOR_FIELD_TO_ADD[Coulumn] IN { "R22"; "R32" });
SELECTEDVALUE( 'Table'[Level] ) = "A3"; CALCULATE([Measure1]; COLOR_FIELD_TO_ADD[Coulumn] IN { "R21" });
SELECTEDVALUE( 'Table'[Level] ) = "B1"; CALCULATE([Measure1]; COLOR_FIELD_TO_ADD[Coulumn] IN { "R1"});
SELECTEDVALUE( 'Table'[Level] ) = "B2"; CALCULATE([Measure1]; COLOR_FIELD_TO_ADD[Coulumn] IN { "R2"; "R22"; "R31"; "R21" });
SELECTEDVALUE( 'Table'[Level] ) = "B3"; CALCULATE([Measure1]; COLOR_FIELD_TO_ADD[Coulumn] IN { "R32" });
SELECTEDVALUE( 'Table'[Level] ) = "C1"; CALCULATE([Measure1]; COLOR_FIELD_TO_ADD[Coulumn] IN { "R1" });
SELECTEDVALUE( 'Table'[Level] ) = "C2"; CALCULATE([Measure1]; COLOR_FIELD_TO_ADD[Coulumn] IN { "R22" });
SELECTEDVALUE( 'Table'[Level] ) = "C3"; CALCULATE([Measure1]; COLOR_FIELD_TO_ADD[Coulumn] IN { "R2"; "R32"; "R31"; "R21" })
)
Formatting =
SWITCH (
TRUE ();
SELECTEDVALUE( 'Table'[Level] ) = "A1"; "Red";
SELECTEDVALUE( 'Table'[Level] ) = "A2"; "Green";
SELECTEDVALUE( 'Table'[Level] ) = "A3"; "Pink";
SELECTEDVALUE( 'Table'[Level] ) = "B1"; "Red";
SELECTEDVALUE( 'Table'[Level] ) = "B2"; "Green";
SELECTEDVALUE( 'Table'[Level] ) = "B3"; "Pink";
SELECTEDVALUE( 'Table'[Level] ) = "C1"; "Red";
SELECTEDVALUE( 'Table'[Level] ) = "C2"; "Green";
SELECTEDVALUE( 'Table'[Level] ) = "C3"; "Pink"
)
Consulte la conexión de resultados.
Hola @MFelix
gracias por volver a alimentarse. Una pregunta
cómo ha vinculado el valor de campo de la tabla "Tabla con la tabla " COLOR_FIELD_TO_ADD
cuando lo hago aparece algún error ?