Calculate number or week attended

[Anonymous]

Hi 

The data I have is call center one, agents will come for a week and will be on leave for a week.

I have a page level filter for latest 8 weeks, now I need buttons like

1 Week

2 Weeks

3 Weeks .... 8 Weeks attended.

If I press "1 week" then the  list has to be filtered to the agents who came only for 1 week.

I am filtering on weekstarting column name.

I can generate the below but no use.

Regards

Drake

[v-yuta-msft]

@Anonymous ,

Have you tried slicer visual in power bi? If possible, could you please share some sample data and clarify more details about your expected results?

Regards,

Jimmy Tao

[Anonymous · Accepted solution]

Now the issues got solved. I have used a table in numbers and chicklet tile added the measure to it with the new table and Boom its done.