Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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
v-gizhi-msft
Community Support
Community Support

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
v-gizhi-msft
Community Support
Community Support

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

Anonymous
Not applicable

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.