Forum Discussion
POWER BI MATRIX VISUAL
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
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.
5 Replies
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.
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.
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
