Issues with date filter on power bi dashboard

[Gasper_11]

Hello,

on the PB dashboard, I am trying to show different measures per month (SLA Met percentage and Count of unassigned tickets). I have created calendar table, which I have connected to input data, based on which I have calculated beforementioned measures. For SLA Met Percentage, everything works fine, measure is correctly shown per month. the problem occurs, when I try to show count of unassigned tickets per month, as data is not shown. I do not know what the issue could be, as I am using the same date column for both measures.

For help, I thank you in advance!

BR

Gašper

[Gasper_11 · Accepted solution]

The solution was in data format of raw data from where the "date for analysis" is taken from. One date was written in "short date" format, the other one in long one. 

[Anonymous]

Hi @Gasper_11 ,

I'm glad you solved the problem, please share the solution if it's convenient and please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Wisdom Wu

[Andreas-Harlak]

Hi @Gasper_11 ,

if I understand you correctly... you have a DateTable an there you grab the Date for analysis, did you grab the Month from the DateTable or from the connected Table. If yo do not grab it from the DateTable try this first. You can transform Monthnumber oder Name in Power Query directly from the Date for analysis.

Maybe if you have more informations about your datasource and you measure I can help more. 

[Gasper_11]

found the solution, thanks anyway