March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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.
is this possible? all the values eventually need to be a drill down as well.
thx,
Luis
Solved! Go to Solution.
HI @Anonymous ,
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
HI @Anonymous ,
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
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 ?
Help when you know. Ask when you don't!
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
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.
Help when you know. Ask when you don't!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
93 | |
90 | |
90 | |
81 | |
49 |
User | Count |
---|---|
160 | |
145 | |
102 | |
72 | |
55 |