Matrix visual

Hi dd88 ,

When you include multiple fields in the Rows and Values area, the Matrix can become cluttered, especially if there are many unique combinations of these fields. To make your Matrix more readable:

1. Simplify the Display: Consider using fewer fields in the Rows area or summarizing your data before it's displayed in the Matrix. This can be done by creating measures that aggregate your data in a way that's meaningful for your analysis.

Incorrect Data Display and Formatting Issues

For the issues related to incorrect data display and formatting:

1. Review Aggregation Settings: In the Values area, Power BI automatically aggregates numeric fields. If your fields like and are being aggregated (e.g., by sum or average), this could lead to incorrect displays. You might want to consider creating measures that correctly calculate the data you want to display, such as the earliest or the latest for each category.

Below is the official link will help you:

Create a matrix visual in Power BI - Power BI | Microsoft Learn

Best Regards,

Xianda Tang

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