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...
  • Jihwan_Kim's avatar
    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.