Filtering data by days

[gtamir]

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 by filtering.

Thanks

[v-caliao-msft]

@gtamir,

You could create a date table and then create relationship between your original table and the new created table, then add the day to a slicer. Please refer to the link below to see the details.
https://docs.microsoft.com/en-us/power-bi/power-bi-visualization-slicers
https://www.mssqltips.com/sqlservertip/4857/creating-a-date-dimension-table-in-power-bi/

Regards,

Charlie Liao

[gtamir]

Thanks,

I have DimDate. Why I can't see 7 rows with the number of violations for each day?

[v-caliao-msft]

@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 · Accepted solution]

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

Giora