Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

Matrix issue

Created one calculated column for combining year and month.

After filtering year, matrix is showing all yeras.

Please help.

Anonymous
5 years ago
amitchandak , Pragati11
Removed coalesce function from measure, resolved my issue. Thanks everyone.

10 Replies

amitchandak
Super User
5 years ago
Anonymous , calculated column or measure?

can you share calculation
- Anonymous
  Not applicable
  5 years ago
  Pragati11
  MMM_YYYY = FORMAT(Dates[Date],"MMM") & "_" & FORMAT(Dates[Date],"yyyy")
  - Pragati11
    Super User
    5 years ago
    Hi Anonymous ,
    
    Can you answer all the points that I asked in my response? 🙂
    
    Thanks,
    
    Pragati
Pragati11
Super User
5 years ago
Hi Anonymous ,

Need more information on your query.

Are Year and Month columns in slicers and your matrix coming from same table?

If not then what kind of relationships you have in your data model?

Do you have a universal Calendar table in your data model?

Thanks,

Pragati
- Anonymous
  Not applicable
  5 years ago
  Yes, I have universal calendar table, and created one calculated column.
  MMM_YYYY = FORMAT(Dates[Date],"MMM") & "_" & FORMAT(Dates[Date],"yyyy")
  - amitchandak
    Super User
    5 years ago
    Anonymous , This can be
    
    MMM_YYYY = FORMAT(Dates[Date],"MMM_yyyy")
    
    But this can nor cause that issue. Make share date table is joined (active join) with your fact and filter of year and month is coming from date table
- Anonymous
  Not applicable
  5 years ago
  Pragati11
  
  Year and Month from Calendar table.
  One to Many (Calendar - Fact)
  Yes, I have universal calendar table.
  - amitchandak
    Super User
    5 years ago
    Anonymous ,Can you share sample pbix after removing sensitive data.