Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

Matrix visual filtering

Hi, In below matrix visual, how do I create slicer to get the blank values? let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8srPyFPSUTI2NzNRitWB8y3MTIzB/ODEX...

Need Help

v-zhenbw-msft
5 years ago
Hi Anonymous ,

Please refer this measure, (Note: you need to create 0/1 table using Enter data function)

Measure 2 = var _select = SELECTEDVALUE('Table (2)'[Column1],1) var _1 = IF( [Measure]=0,BLANK(),1) var _0 = IF( [Measure]=1,BLANK(),0) return IF( _select=1,_1,_0)

Best regards,

Community Support Team _ zhenbw

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

BTW, pbix as attached.
Matrix visual filtering.pbix27 KB

v-zhenbw-msft

Community Support

5 years ago

Hi Anonymous ,

Sorry for that you cannot only get the blank value in this matrix table unless you change it to a table visual.

Or you can configure some background colors in it.

Please refer the steps below.

1. Create a new table.

Table = CROSSJOIN(VALUES(Query1[Customer]),VALUES(Query1[SoldProductID]))

2. Create a measure to get the blank value as 0.

Measure = 
CALCULATE(
    COUNT(Query1[Customer]),
    FILTER(
        Query1,
        Query1[Customer]=MAX('Table'[Customer])
        &&Query1[SoldProductID]=MAX('Table'[SoldProductID]))) + 0