Forum Discussion

Malfunction's avatar
Malfunction
Regular Visitor
9 years ago

Filtering Confusion!

Hi I have created a matrix report in Power Bi Desktop to display student weekly attendance for the last 5 weeks, so setup is as follows: Rows - Student Name, Columns - Week Commencing, Values - % ...
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi Malfunction,

 

Based on my research, it's more like an error that generated from SQL server. And the problem may be related to the time zone setting. Here is a similar thread for your reference.:smileyhappy:

 

Regards

  • Malfunction's avatar
    Malfunction
    Regular Visitor
    9 years ago

    Thanks, clearly hadn't got my head screwed on yesterday, definitely something it doesn't like with the week commencing date data as the filter works if I change the columns to use week number instead of wc date.  I'll look into that although I'm sure the data is all valid at least.  Just need to work out how to filter on the total of the 2 weeks now!