Date slicer not updating Avg time

[tatees]

Hi All,

I have below tables connected with each other

I want to show, number of W Queries and Avg Time W queries column for each employee.

number of W queries & Avg time W queries are coming accurately. but when I move date slicer it doesn't update Av time W queries column. It only updates No of W queries. 

Date slicer is connected with Queries table Date column.

How to get this working?

Appreciate any help with this.

[v-tangjie-msft · Accepted solution]

Hi @tatees ,

You can create a measure instead of a calculated column.

This is my model relationship.

Use the [Date] of the date table as the value of the slicer. This measure changes when the slicer is slid.

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. Thank you.

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[Wilson_]

tatees,

Can you please share how you're calculating the two columns?

[tatees]

30_No.OfWQueries =

CALCULATE(

    COUNTROWS(Queries)

31_Av.TimeWQueries =

VAR TotalDurationMinutes =

CALCULATE(

    SUM('Timesheet (Queries)'[new_durationminsonly])

)

VAR TotalDurationHours =

TotalDurationMinutes/60

VAR NumberOfJobs =

CALCULATE(

    DISTINCTCOUNT('Timesheet (Queries)'[ssw_jobid])

)

VAR AvTimeWQueries =

TotalDurationHours/NumberOfJobs

RETURN

AvTimeWQueries

[Wilson_]

tatees,

I'm guessing the Date slicer on the page is using the Date field from the Queries table? There's no relationship between your Date Table and Queries, but it's the measure using the Queries table that updates when you change the date slicer.

In that case, you need a relationship between Date Table and Queries, and to use the Date field from the Date Table in your slicer.

If that's not the issue, can you please share a sample pbix file? (If you don't know how, please check the pinned thread in the forum.) It would make debugging your issue easier. 🙂

----------------------------------
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?)

[tatees]

Thanks Wilson,

I tried creating relationship between date table and queries, but that doesn't work. 

Due to client live data, I cannot share pbix file unfortunately. 

Many thanks 

[Wilson_]

tatees,

Understandable, but if you can't share a pbix, you're going to have to give feedback that's way more helpful than "doesn't work". 🙂