Matrix issue

[Anonymous]

Created one calculated column for combining year and month.

After filtering year, matrix is showing all yeras.

Please help.

[Pragati11]

Hi @Anonymous ,

Need more information on your query.

1. Are Year and Month columns in slicers and your matrix coming from same table?
2. If not then what kind of relationships you have in your data model?
3. Do you have a universal Calendar table in your data model?

Thanks,

Pragati

[Anonymous]

@Pragati11 

Year and Month from Calendar table.

One to Many (Calendar - Fact)

Yes, I have universal calendar table.

[amitchandak]

@Anonymous ,Can you share sample pbix after removing sensitive data.

[Anonymous · Accepted solution]

@amitchandak , @Pragati11 

Removed coalesce function from measure, resolved my issue.  Thanks everyone. 

[Anonymous]

Yes, I have universal calendar table, and created one calculated column.

MMM_YYYY = FORMAT(Dates[Date],"MMM") & "_" & FORMAT(Dates[Date],"yyyy")

[amitchandak]

@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]

@amitchandak 

Instead of Year-Month, Month coulmn is working fine in Matrix.

The above formula also giving same result.

[amitchandak]

@Anonymous , calculated column or measure?

can you share calculation

[Anonymous]

@Pragati11 

MMM_YYYY = FORMAT(Dates[Date],"MMM") & "_" & FORMAT(Dates[Date],"yyyy")

[Pragati11]

Hi @Anonymous ,

Can you answer all the points that I asked in my response? 🙂

Thanks,

Pragati