Forum Discussion
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 by filtering.
Thanks
Thaks Charlie, I found the problem. The date column was TEXT type by mistake.
Giora
4 Replies
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
Thanks,
I have DimDate. Why I can't see 7 rows with the number of violations for each day?
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
