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