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 =
IF (
SELECTEDVALUE ( Tableau1[Choice] ) = "A",
SWITCH (
TRUE (),
MAX ( 'COLOR_FIELD_TO_ADD'[Coulumn] ) IN { "R1", "R2", "R31" }, "Red",
MAX ( 'COLOR_FIELD_TO_ADD'[Coulumn] ) IN { "R2", "R32" }, "Green",
MAX ( 'COLOR_FIELD_TO_ADD'[Coulumn] ) IN { "R21" }, "Pink "
),
IF (
SELECTEDVALUE ( Tableau1[Choice] ) = "B",
SWITCH (
TRUE (),
MAX ( 'COLOR_FIELD_TO_ADD'[Coulumn] ) IN { "R1" }, "Red",
MAX ( 'COLOR_FIELD_TO_ADD'[Coulumn] ) IN { "R2", "R22", "R31", "R21" }, "Green",
MAX ( 'COLOR_FIELD_TO_ADD'[Coulumn] ) IN { "R32" }, "Pink "
),
SWITCH (
TRUE (),
MAX ( 'COLOR_FIELD_TO_ADD'[Coulumn] ) IN { "R1" }, "Red",
MAX ( 'COLOR_FIELD_TO_ADD'[Coulumn] ) IN { "R22" }, "Green",
MAX ( 'COLOR_FIELD_TO_ADD'[Coulumn] ) IN { "R2", "R32", "R31", "R21" }, "Pink"
)
)
)
es posible hacer los resultados dependiendo de la opción A,B,C y en tres líneas en la mesa y no 6 como en los resultados de Power BI
Se ha corregido la condición de tres filas como A, B, C
El proyecto está en el enlace adjunto haga clic aquí
gracias por la ayuda
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.
9 Replies
Hola @POWER_MI ,
Utilice la misma fórmula que tiene para el couloring pero para el cálculo de measure1:
Calculation = IF ( SELECTEDVALUE ( Tableau1[Choice] ) = "A"; SWITCH ( TRUE (); MAX ( 'COLOR_FIELD_TO_ADD'[Coulumn] ) IN { "R1"; "R2"; "R31" }; [Measure1]; MAX ( 'COLOR_FIELD_TO_ADD'[Coulumn] ) IN { "R2"; "R32" }; [Measure1]; MAX ( 'COLOR_FIELD_TO_ADD'[Coulumn] ) IN { "R21" }; [Measure1] ); IF ( SELECTEDVALUE ( Tableau1[Choice] ) = "B"; SWITCH ( TRUE (); MAX ( 'COLOR_FIELD_TO_ADD'[Coulumn] ) IN { "R1" }; [Measure1]; MAX ( 'COLOR_FIELD_TO_ADD'[Coulumn] ) IN { "R2"; "R22"; "R31"; "R21" }; [Measure1]; MAX ( 'COLOR_FIELD_TO_ADD'[Coulumn] ) IN { "R32" }; [Measure1] ); SWITCH ( TRUE (); MAX ( 'COLOR_FIELD_TO_ADD'[Coulumn] ) IN { "R1" };[Measure1]; MAX ( 'COLOR_FIELD_TO_ADD'[Coulumn] ) IN { "R22" }; [Measure1]; MAX ( 'COLOR_FIELD_TO_ADD'[Coulumn] ) IN { "R2"; "R32"; "R31"; "R21" }; [Measure1] ) ) )@POWER_MI , Selectedvalue debería haberlo hecho. ¿cuál es el reto?
