How to filter data by date and filter the rest of the visual

pipanebo — Tue, 04 Apr 2023 14:27:46 GMT

Hello,

My database is like this:

I'm trying to filter some data by date, but when I choose different months the visual of some charts doesn't show up and I get this error:

I'm trying to show average time of an activity in a column chart, as shown below:

This average time is calculated like this:

Tempo médio de furação = CALCULATE(AVERAGEA(PLANILHA[TEMPO FURO]),PLANILHA[TEMPO FURO]<>BLANK())

Média Furo Valor =
VAR HOR = (HOUR([Tempo médio de furação]) + ([Inteiro tempo]*24))
VAR MINU = MINUTE([Tempo médio de furação])
VAR SEG = SECOND([Tempo médio de furação])
VAR H = FORMAT(HOR,"00")
VAR M = FORMAT(MINU,"00")
VAR S = FORMAT(SEG,"00")
Return
VALUE (H & M & S)

When I try to filter this data by date (which I have a column associating all the data) I get the error.

Re: How to filter data by date and filter the rest of the visual

Wilson_ — Wed, 05 Apr 2023 12:05:39 GMT

Hello pipanebo,

Based on the error message, it looks like you have values in the TEMPO FURO column that aren't actually blanks, but instead are empty strings. For example, can you go into Power Query on your table and check that the value of the first row is actuall null?

This other thread might be of use to you.

----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

topic Re: How to filter data by date and filter the rest of the visual in DAX Commands and Tips

How to filter data by date and filter the rest of the visual

Re: How to filter data by date and filter the rest of the visual