Help with a Matrix Visual needing to show all data based on a condition in a slicer

[Anonymous]

Goodday,

I have been trying to get the following to work for some hours but i have been unable to.

I have data that looks like

That makes a matrix visual that looks like

Now i want to be able to select a month in a slicer, and then if that month has a  1 in the values, that it displays all months for that row.

A bit like when i select "Feb", that it displays

And when i select jan that it displays

Does anyone know how i would achieve this?

[Anonymous · Accepted solution]

Hi  @Anonymous 

You can refer to the following example

1.You need to create a new table to as a filter

2.Then create two meausre

Measure = var a=FILTER(ALLSELECTED('Table'),[Month] in VALUES('Table 2'[Month])&&[Showup]=1)
return COUNTROWS(FILTER(a,[A] in VALUES('Table'[A])&&[B] in VALUES('Table'[B])))

Measure 2 = IF(ISFILTERED('Table 2'[Month]),IF([Measure]>0,CALCULATE(SUM('Table'[Showup]))),SUM('Table'[Showup]))

3.Then put the measure 2 to the visual matrix and put the month field of table2 to the slicer

Output

Best Regards!

Yolo Zhu

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

[Anonymous]

Goodday! Thank you for the help, interesting measures for sure. Sadly enough i think i do something wrong because it doesnt seem to work. Empty values display as empty instead of 0, and because of that the slicer still doesnt work. 

Any idea why?

[Anonymous]

Hi @Anonymous 

You need to put the "Month" column of sheet 1 to column of the matrix instead of putting the "Month" column of Month table to it.

Best Regards!

Yolo Zhu

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

[Anonymous]

It works like a charm! Thank you very very much!