Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Problem With Slicers And Matrices

I'm trying to setup a page with two matrix visuals and two slicers.  First, the two slicers looks like this: This will allow the user to select the year and the month.  One matrix is already s...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

 

Here's my solution.

1.Create a seperate calendar table for the two slicer.

 

2.Create a mesaure to filter for the first visual. Put the measure into filters and set up show items when the value is 1.

visual-level-filter = var _date=MAX('Table'[Date])
return IF(MONTH(_date)<=SELECTEDVALUE('Table 2'[Date].[MonthNo])&&YEAR(_date)=SELECTEDVALUE('Table 2'[Date].[Year]),1)

 

3.Create another measure to get the year to date value.

YTD = CALCULATE(SUM('Table'[Value]),FILTER(ALLSELECTED('Table'),MONTH([Date])<=SELECTEDVALUE('Table 2'[Date].[MonthNo])&&YEAR([Date])=SELECTEDVALUE('Table 2'[Date].[Year])))

 

 

 

Best Regards,

Stephen Tao

 

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Stephen,

     

    I tried your solution but, unfortunately, I couldn't get it to work.  It caused the first matrix that was working to no longer work and I couldn't get the second matrix to work at all.

     

    I appreciate the time and effort.

     

    Scott