cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ldpozo68 Frequent Visitor
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
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
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
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
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.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors