Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    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.

     

     

     

     

     

     

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
3 years ago

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