Power BI Desktop Matrix visual date issue

[Anonymous]

Dear all,

I have recently faced an issue with Power BI Desktop matrix visual issue:

When I use different categories as row and add the date to values then I can only choose between First and Last date but that means the First or Last date in the total column without taking into consideration the categories in the row level.

How can I solve this issue, moving date field to rows results incorrect date value? May not solve the issue.

Thank you 

[amitchandak]

Did Not get the complete issue. Why don't you you put date in row with other dimension/parameter

[Anonymous]

@amitchandak 

Moving Date from VALUES to ROW will not solve the issue.

I need to understand if there is any way to use dyanmic dates as VALUES which will change to the correct date instead of Earliest and Latest.

Any solution for this?

[v-kelly-msft · Accepted solution]

Hi @Anonymous ,

Yes,you can create a measure to achieve it,but if the date is an existing value in your column  and you just wanna show it in a matrix, then you only need to drag it to row:

Then go to format >Row headers>Stepped layout : off   subtotals>row subtotals : off

Finally you will see:

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@Anonymous , Can you explain with example