cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Chema_Ortega
Helper III
Helper III

Formato Condicional

 Hola    Espero que todos estén bien 

 

Mira la foto de abajo. Me gustaría colorear los datos solo cuando el número de semana es la semana actual (tengo una medida para la semana actual = 

WEEKNUM (HOY ())
 
¿Es posible? Muchas gracias por adelantado. ¡Mis mejores deseos y saludos!
 
Chema
5 REPLIES 5
amitchandak
Super User
Super User

@Chema_Ortega 

These are a few examples of how can you create a color measure

Color Date = if(FIRSTNONBLANK('Date'[date],TODAY()) <today(),"lightgreen","red")
Color sales = if(AVERAGE(Sales[Sales Amount])<170,"green","red")
Color Year = if(FIRSTNONBLANK('Date'[Year],2014) <=2016,"lightgreen",if(FIRSTNONBLANK('Date'[Year],2014)>2018,"red","yellow"))

 

In conditional formatting under advance, control choose field option and choose such a measure, You will get the desired result

https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values



Power BI Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!
Want To Learn Power BI | Beginners !! Advance Concepts !! Power BI For Tableau User !!

Captura11111.JPG

Muchas gracias!!!

 

Lo que necesito es que sólo una fila de la Tabla se ponga en rojo si la semana de la fila es la semana en la que estamos ahora mismo... Sólo quiero que cambie de color esa fila, no el resto... ¿Es posible?

Pragati11
Super User
Super User

Hi @Chema_Ortega ,

 

I think yoy forgot to attach the picture. Can you please do that?

 

Thanks,
Pragati

Best Regards,

Pragati Jain

MVP logoDACertAzCert

LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

I've just did it. Thanks a lot!

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors