Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
this is my matrix:
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
Solved! Go to Solution.
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:
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:
Hope this helps.
Best Regards,
Giotto Zhi
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:
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:
Hope this helps.
Best Regards,
Giotto Zhi
thx for the solution. didnt even think of creating a new table.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |