Need help with Status Bar in Power BI

[KK_B]

Hello Experts,

I need some of your help with my below requirement:

I have a table in power bi with these data:

CallDateTime        Status

3/19/23 8:55 AM     1

3/19/23 8:50 AM     1

3/19/23 8:45 AM     0

3/19/23 8:40 AM     1

3/19/23 8:35 AM     0

3/19/23 8:30 AM     0

3/19/23 8:25 AM     1

etc

I want to show the status bar with this conditions:

If sum(status) for last three calldatetime values = 3 then green

   sum(status) for last three calldatetimevalues = 2 then yellow

   sum(status) for last three calldatetimevalues = 1 then orange

  sum(status) for last three calldatetimevalues = 0 then red.

If I select the date ranges in the report filter then status bar has to do the calculations for that date range.

Can some one please help me with this request?

Thanks,

KKB

[amitchandak · Accepted solution]

@KK_B , Create a measure like

 M1= sum(Table[status])

Then create a color measure

Color = Switch( True() ,

[M1] >= 3, "Green",

[M1] = 2, "Yellow",

[M1] = 2, "Orange",

"Red")

Use color measure in conditional formatting using the 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/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...