cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ldpozo68 Frequent Visitor
Frequent Visitor

Can values be filetered per column based on the day of the week.?

I have a dataset that shows outstanding work by regional offices (RAO). The types of worksare defined by the column header (key, verify, etc..).

My data shows all the outstanding work that needs to be completed.

A requirement is that the user can filter by day of the week and the matrix will only show that days work.

the tricky part is that each type of work (key, verifiy etc...) has different offices defined per column. For instance mondays only offices 15, 28, 29, 30, 31, 32 are to be shown for 'key' column and offices for 'VERIFY' are 2, 6, 17, 18, 21, 23.

the following is the matrix.
I have highlighted the key and verifiy column with the respective offices for monday.

 

daysofweek.png

 

is this possible? all the values eventually need to be a drill down as well.

 

thx,

Luis

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Can values be filetered per column based on the day of the week.?

HI @ldpozo68 ,

I'd like to suggest you create a mapping table to mapping correspond workday of 'key' and 'verify' fields values.

WorkDay Attribute Value
1 key 7
1 key 16
1 key ...
1 Verify 2
1 Verify 109
1 Verify ...

Then you can add a visual level filter on matrix visual to filter records who selected in mapping table to use workday numbers to filter correspond values.

If you confused about coding formula, can you please share some sample data to test?

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI

View solution in original post

4 REPLIES 4
Super User II
Super User II

Re: Can values be filetered per column based on the day of the week.?

Luis,

Do you wish to display the undone work based on a specific day. For example, you have a slicer, the user chooses a date, it's a monday.

Then you want to see in the graph the undone work for the offices that work on Monday ?





Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!




ldpozo68 Frequent Visitor
Frequent Visitor

Re: Can values be filetered per column based on the day of the week.?

yes that is exactly right. I dont know what a slicer is... im a sharepoint architect doing some powerbi for the 1st time.

 

The challenge is that each column has different offices (RAO) to display the undone work for that day of the week.

 

Luis

 

 

Super User II
Super User II

Re: Can values be filetered per column based on the day of the week.?

Luis, I understand.

When you first jump into Power BI there are a lot of new things to deal with.

In this case I think I could help you more if you had time to do a screen share and we could talk this over in person.

If that seems good, let me know a good time and day to call and I'll send you a Zoom meeting invitation.

Email me at ken@8thfold.com.





Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!




Community Support Team
Community Support Team

Re: Can values be filetered per column based on the day of the week.?

HI @ldpozo68 ,

I'd like to suggest you create a mapping table to mapping correspond workday of 'key' and 'verify' fields values.

WorkDay Attribute Value
1 key 7
1 key 16
1 key ...
1 Verify 2
1 Verify 109
1 Verify ...

Then you can add a visual level filter on matrix visual to filter records who selected in mapping table to use workday numbers to filter correspond values.

If you confused about coding formula, can you please share some sample data to test?

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors