Forum Discussion

gtamir's avatar
gtamir
Post Patron
8 years ago
Solved

Filtering data by days

Hi   I have DimDate, FactParkingViolation[DateIssued], and FactParkingViolation[NumberOfViolation]. How can I create a report shoing the number of violations per day of the week? Couldn't find it...
  • gtamir's avatar
    gtamir
    8 years ago

    Thaks Charlie, I found the problem. The date column was TEXT type by mistake.

     

    Giora

v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
8 years ago

gtamir,

 

Could you please share us some screenshots about your report, it hard to understand your issue based on your decription. You can upload a pbix file to Onedrive or any web storage and share the link. Do mask sensitive data before uploading.

 

Regards,
Charlie Liao

gtamir's avatar
gtamir
Post Patron
8 years ago

Thaks Charlie, I found the problem. The date column was TEXT type by mistake.

 

Giora