Matrix visual - date

[ronaldbalza2023]

Hi everyone, 

I have a matrix visual with a measure and a date on it. However, on the date column, there were dates that have been showing and dates that haven't. I have the date field in the values, not in columns/rows. How can I fix this? Thanks in advance.

[Anonymous · Accepted solution]

Hi @ronaldbalza2023 , 

I think this is based on your data model, you add a date column in value field in matrix not a measure. If data column has value for these hierachy level, it will show values in visual. As amitchandak mentioned before, we need more details like your data model, a sample file to help you solve your problem. 

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@ronaldbalza2023

[amitchandak]

@ronaldbalza2023 ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.