cancel
Showing results for
Did you mean:

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

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!

1 ACCEPTED SOLUTION
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:

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"

Use the Date[Date] as the slicer
Final output

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

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:

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"

Use the Date[Date] as the slicer
Final output

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