Forum Discussion
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...
Thaks Charlie, I found the problem. The date column was TEXT type by mistake.
Giora
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?