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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Syndicate_Admin
Administrator
Administrator

Medir

Hola

solo quiero saber la fórmula para debajo de la lógica cómo escribir

  • YTD <= YEP , Verde
  • YTD > YEP, varianza entre 1% - 5%, Ámbar
  • YTD > YEP, varianza > 5%, Rojo

plese ayuda sobre la lógica anterior

1 ACCEPTED SOLUTION
Syndicate_Admin
Administrator
Administrator

@sprao ,

Suponga que YTD y YEP son medidas que tiene. Crear una medida y usarla en formato condicional mediante la opción de valor de campo

Interruptor ( True() ,

[YTD] <= [YEP] , "Verde" ,

[YTD] <[YEP] *1.05 , "Ámbar",

[YTD] >=[YEP] *1.05, "Rojo"

)

Formato condicional del objeto visual circular: https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...

View solution in original post

1 REPLY 1
Syndicate_Admin
Administrator
Administrator

@sprao ,

Suponga que YTD y YEP son medidas que tiene. Crear una medida y usarla en formato condicional mediante la opción de valor de campo

Interruptor ( True() ,

[YTD] <= [YEP] , "Verde" ,

[YTD] <[YEP] *1.05 , "Ámbar",

[YTD] >=[YEP] *1.05, "Rojo"

)

Formato condicional del objeto visual circular: https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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