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

I need to create a filter for day of the week combined with other values

this is my matrix:

 

newMatrix.png

 

The requirement is that on monday I only show rows with key values 15, 28, 29, 30, 31, 32. My thoughts are that you create a custom column that returns records with key values 15, 28, 29, 30, 31, 32 but how  it is combined with the day of the week is beyond me.

 

Furthermore, there needs to be radio buttons so they can change the day of the week from 'today' to any other day of the week or the whole week.

 

Any help would be appreciated.\

 

Regards,

Luis

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft v-gizhi-msft
Microsoft

Re: I need to create a filter for day of the week combined with other values

Hi,

 

According to your description, i am confused with the [RAO] means? is it the number of each week?

If so, i create some data to test:

101.PNG102.PNG

Then, create a calculated table:

Table 2 = FILTER(ALLSELECTED('Table'),([Measure]=15||[Measure]=28||[Measure]=29||[Measure]=30||[Measure]=31||[Measure]=32)&&'Table'[DAY]="Mon")

And it shows:

103.PNG

 

Hope this helps.

 

Best Regards,

Giotto Zhi

View solution in original post

2 REPLIES 2
Highlighted
Microsoft v-gizhi-msft
Microsoft

Re: I need to create a filter for day of the week combined with other values

Hi,

 

According to your description, i am confused with the [RAO] means? is it the number of each week?

If so, i create some data to test:

101.PNG102.PNG

Then, create a calculated table:

Table 2 = FILTER(ALLSELECTED('Table'),([Measure]=15||[Measure]=28||[Measure]=29||[Measure]=30||[Measure]=31||[Measure]=32)&&'Table'[DAY]="Mon")

And it shows:

103.PNG

 

Hope this helps.

 

Best Regards,

Giotto Zhi

View solution in original post

ldpozo68
Frequent Visitor

Re: I need to create a filter for day of the week combined with other values

thx for the solution. didnt even think of creating a new table.

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors