Forum Discussion
Power BI Desktop Matrix visual date issue
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
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,
KellyDid I answer your question? Mark my post as a solution!
4 Replies
Did Not get the complete issue. Why don't you you put date in row with other dimension/parameter
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?
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,
KellyDid I answer your question? Mark my post as a solution!
