Forum Discussion

Anonymous's avatar
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's avatar
    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.

v-zhenbw-msft's avatar
v-zhenbw-msft
Community Support
5 years ago

Hi Anonymous ,

 

You can create another measure and put it in values.

 

Measure 2 = 
IF(
    [Measure]=1,BLANK(),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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi v-zhenbw-msft 

    Is there a way to create a slicer with 1 and 0 so that when i select 1 it shows only 1 in the matrix and when i select 0 it shows only 0 in the matrix? Instead of putting it in the values

    • v-zhenbw-msft's avatar
      v-zhenbw-msft
      Community Support
      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Thanks v-zhenbw-msft