Forum Discussion
AdministratorLight up Fields in a date range
Nice day
I am generating a Dashboard in which there is a table that shows me values, however, I need to illuminate the values that have the last 3 dates, that is, today, yesterday and antier. Could someone guide me?
Syndicate_Admin , if they are in table visual, you can use conditional formatting with field value option use a measure like one given below
COlor = Switch(True() ,
max(Date[Date]) = today() , "Green",
max(Date[Date]) = today()-1 , "Yellow",
max(Date[Date]) = today()-1 , "Blue", "White"
)
Use in cell element -> background color- > field value option
How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3
1 Reply
- amitchandak
Super User
Syndicate_Admin , if they are in table visual, you can use conditional formatting with field value option use a measure like one given below
COlor = Switch(True() ,
max(Date[Date]) = today() , "Green",
max(Date[Date]) = today()-1 , "Yellow",
max(Date[Date]) = today()-1 , "Blue", "White"
)
Use in cell element -> background color- > field value option
How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3