POWER BI MATRIX VISUAL

[CR7]

I have a power bi matrix that show the sales per client with  4 Year/Month columns. Is Possible to view only the total of the year sales for the first 2 years and for the last 2 years view year/Month  sales.

                    year 1      year 2       year 3                    year 4

                    total         total         Jan Fev .... Dez        Jan Fev ...

client 1

client 2

[Jihwan_Kim · Accepted solution]

Hi,

One of ways to create like this is to have a dim calendar table like the below sample.

I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

[CR7]

the solution is ok.

Is possible to do the same with the capacitiy to years 2019 and 2020 be aggregate (only year) or disaggregate (Year/Month).

[Jihwan_Kim]

Hi,

Thank you for your feedback, and I think it is possible if we can apply the similar logic to create a [new axis 2] column.

[CR7]

OK. Thanks

[PaulDBrown]

Two ways:

1) Hide the unwanted columns by turning off "Word wrap" for the column headers and dragging the right column boundary left to "hide" the column

2) Create a custom layout for the matrix columns

Creating a custom matrix