Forum Discussion

ovetteabejuela's avatar
ovetteabejuela
Impactful Individual
9 years ago
Solved

Matrix Visual Not Filtering at the Column

Hi community!   This is weird Matrix does behave properly when       I have an Interval(table Field) by 30 minutes in my Row Section        A Date field on the column (as headers)      and a cou...
Need Help
  • ovetteabejuela's avatar
    ovetteabejuela
    9 years ago

    Okay so the Matrix need a little help from HASONEVALUE.

     

    I think I got this now.

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi ovetteabejuela,

It’s difficult to reproduce your scenario based on your decription and find the reason. Is there any chance to post your sample data or .pbix file for analysis? So that we can post solution which is close to your requirement. 

Best Regards,
Angelia

ovetteabejuela's avatar
ovetteabejuela
Impactful Individual
9 years ago

One suspect is the FORMAT command on one of the values.

 

Say I have in the column Date

Some category on the Rows

and values in the Values section

 

if I issue a FORMAT command, and if I have a MONTH filter it does not filter on the dates - it shows all the days I have in that table.

  • ovetteabejuela's avatar
    ovetteabejuela
    Impactful Individual
    9 years ago

    Okay so the Matrix need a little help from HASONEVALUE.

     

    I think I got this now.

    • pcabrero's avatar
      pcabrero
      Advocate II
      9 years ago

      Please ovetteabejuela, could you share the complete solution???? I've found the same issue and I do not unserstand the tip you gave.

       

      MANY THANKS ins advance!!!!