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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
EsterBR
Helper II
Helper II

Matrix - Month up to the date selected in the slicer

Hi,

 

I have a slicer with a date and a matrix. I would like that when a date is selected in the slicer, the matrix shows the months up to that date. For example, if the 9th of March is selected in the slicer sales should show from the 1st January till the 9th of March by month. How can I achieved this? Thanks! 

 

EsterBR_0-1712785421202.png

 

1 ACCEPTED SOLUTION
v-heq-msft
Community Support
Community Support

Hi @EsterBR ,
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:

vheqmsft_0-1712797860886.png

Create a Date table that values Table[Date]

Date = VALUES('Table'[Date])

Create a meaure

Measure = 
IF(
    SELECTEDVALUE('Table'[Date]) <= SELECTEDVALUE('Date'[Date]),
    1,
    0
)

Apply the meaure to the filter of the matrix and set it as "is 1"

vheqmsft_1-1712797992471.png

Use the Date[Date] as the slicer
Final output

vheqmsft_2-1712798080779.png

Best regards,

Albert He

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

 



View solution in original post

1 REPLY 1
v-heq-msft
Community Support
Community Support

Hi @EsterBR ,
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:

vheqmsft_0-1712797860886.png

Create a Date table that values Table[Date]

Date = VALUES('Table'[Date])

Create a meaure

Measure = 
IF(
    SELECTEDVALUE('Table'[Date]) <= SELECTEDVALUE('Date'[Date]),
    1,
    0
)

Apply the meaure to the filter of the matrix and set it as "is 1"

vheqmsft_1-1712797992471.png

Use the Date[Date] as the slicer
Final output

vheqmsft_2-1712798080779.png

Best regards,

Albert He

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

 



Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.