Filter by Sunday & All Public Holidays

[android1]

Hi,

I have a calculated column Day = WEEKDAY(vw_PivotChargesFrontPage[Visits_Date],2).

If I select 7 in a slicer then my data is filtered for Sundays.

I have a column VisitsDate which contains the date of every day in the year. I have created a group (Public Holiday) from this & put every date that is a public holiday in it. I apply this to a slicer & when I select Public Holiday my data is filtered to show only Public Holiday data.

How do I show data from Public Holidays & Sundays at the same time?

[v-piga-msft]

Hi @android1,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you need additional help, please share some data sample and your expected output.

Best Regards,

Cherry

[v-piga-msft · Accepted solution]

Hi @android1,

I 'm not clear about how do you group your public holiday. I just made a test with a sample data accoring to your description.

I grouped several days from column Visits_Date as holiday and the rest as other group.

Also I created the Day column with your formula.

Then I create the two Slicer with Day and the Group like below which could filter out the days that are Public Holidays & Sundays.

Hope this what you want. If I misunderstand your requirement, please share some data sample and your expected output.

Best Regards,

Cherry

[alexei7]

Hi @android1,

I'm a bit confused about what your data looks like.

Would you be able to share samples of your table(s)?

Thanks

Alex