Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

columns which doesnt have data should not show in matrix table

I have requirement that when user selects a quarter in a slicer it should show data of all months for that quater in a matrix table, however it shoud not show the month if ther is no data for any col...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Anonymous 

    It's impossible to achieve that with DAX. But you may get it in Query Editor.Filter the value1 table in query editor as above mentioned.Then group the two tables to get summarized Amt columns.Then merge the two tables for Value1 table.Attached sample file for your reference.

    Regards,

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi kanth452,

it didnt work becuase values will be available for 'Amt 2' column for that month,so it will show  'Amt 1' as blanks.

so we need to ignore that  month from the table itself if 'Amt 1' values are not there.

v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous 

It's impossible to achieve that with DAX. But you may get it in Query Editor.Filter the value1 table in query editor as above mentioned.Then group the two tables to get summarized Amt columns.Then merge the two tables for Value1 table.Attached sample file for your reference.

Regards,