How to make a bar graph that evaluates one of the worst devices in the 7-day range

[diegolima]

Hello guys, how are you?

I have a table that calculates 4 measurements a device makes per day throughout the month. I need to make a bar chart that separates equipment that has a 3-day average below 80 in the 7-day range. How could I do it?

Can anybody help me?

Thank you all!

[amitchandak]

@diegolima , three days for each day in the last seven or the last three day?

Remove less that .8

Rolling =
var _1 =
CALCULATE(AverageX(Values('Date'[Date]), [Measure]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-3,Day))

return
if(_1 < .8 , blank(), _1)

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[diegolima]

Hi @amitchandak thanks for help,

I need make a bar graph like this:

And my table is like this:

I need selected one number for day of column "Equipamento" that don't be in blank in the column "Conteudo" and that column "MEDIA" have value above 8000, but my user always will go selected this ranhe of 7 days, for this I need that this information has ocurred for 3 days. In short, in the range of 7 days, select "Equipamento" with an average above 8000 in the column "MEDIA" for 3 days.

Thank you very much in advance