This option isn't good neither in Excel nor, of course, in Power BI.
What I've tried?
Create a new table with one column where are the days.
Distinct counts of SN from original table.
And now, with the help of and slicer I want to use both tables in the same page filtering by SN and by date, but I have issues when I link the tables. I've used a link Many to One form original table (same day due to events in different rows) to the new table (one different day per row). Then, when I use the slicer to select the time frame is all ok, but doesn't apply the SN filter also I have.