Create custom matrix visualization

[garciamaxim27]

Hello everyone,

I am new to developing analytical solutions using Power BI. I'm going to introduce the context and what I want to do.

I have an excel with this data:

This table has items with some dates and some category types. I want to construct a matrix or pivot table with types in rows and months/year in columns. In the data pane, I need to do a distinct count from rows of item columns. But, I need to add some extra columns at the last of this matrix, these columns are the difference between the current month and last month. Another column has a trend from the current month. The trend is a calculation based on current labor days and total labor days of the current month. Another column is the percentage of variation between the trend and last month. The last column is the total sum of all the months only. The resulting matrix done in excel must look like this:

I want to do this in Power BI. I have used the matrix visualization that shows correctly the first part of a matrix (types and months data). But I don't know how to incorporate or add the rest of the measures/metrics. I have created some metrics, but when I add in the "Values" section, it plots a measure for all months.

Also, I need to show a line chart graph comparison between last month and the trend 

* The current date or month must be relative or calculated and It must be obtained as a maximum of a column DATE

All the files related are in this link

Could someone help me by giving me some tips or ideas about how to build the report that I need to do?

I am free to use any visualization or element. I think I have no restrictions.

Thanks in advanced.

[lbendlin]

"I want to do this in Power BI. I have used the matrix visualization that shows correctly the first part of a matrix (types and months data). But I don't know how to incorporate or add the rest of the measures/metrics. I have created some metrics, but when I add in the "Values" section, it plots a measure for all months."

Yes, that's how Power BI is designed.  Your desire to add summary columns at the end of a matrix clashes with the design principles for matrix visuals. 

Couple options:

- disable column word wrap and then hide columns you don't want

- create a fully custom matrix visual with independent measures for all the value columns

- rethink your approach and use two separate matrix visuals.