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.

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
    amitchandak
    Instead of Year-Month, Month coulmn is working fine in Matrix.
    The above formula also giving same result.
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.
  - Anonymous
    Not applicable
    5 years ago
    amitchandak , Pragati11
    Removed coalesce function from measure, resolved my issue. Thanks everyone.