month below year in matrix

[powerbiexpert22]

i want to show months below years in matrix chart as shown below in blue color. please see the pbix for reference

pbix: https://drive.google.com/file/d/18hl433KqguZf-BDX4aGoXKQN3Oo1i0W4/view?usp=drive_link

current results:

[DataNinja777]

Hi @powerbiexpert22 ,

To achieve the desired visual effect, place the year and month fields in the Columns section of the matrix visual, as shown below. 

Next, click the double arrow in the top right corner of the visual to expand the month field under the year field.

Best regards,

[shafiz_p · Accepted solution]

Hi @powerbiexpert22  Please right click on column header and select expand to the next level. You will get your desired result. see the image below:

Desired output:

Hope this helps!!

If this solved your problem, please accept it as a solution!!

Best Regards,
Shahariar Hafiz

[powerbiexpert22]

Hi @shafiz_p ,

when i clicked on "Expand to next level" it is only showing me july month, how did you acheive the desired output

[shafiz_p]

@powerbiexpert22  Please check if there is any filter applied. I have done nothing. This is same as your provided file. I have also check using month name and getting the same result. Both image given below:

Hope this will solve your problem.

[powerbiexpert22]

Hi @shafiz_p ,

please see below pbix file which is showing incorrect results. i do not see any filters

pbix:

https://drive.google.com/file/d/1oQUa6uiLP2ZrDY420Ef1nKaejiT9-7kW/view?usp=drive_link

[shafiz_p]

@powerbiexpert22  Your month formula is wrong. Please check image. You have only 1 month july in Month column thats why you are getting only july. Fix the formula. 

Month = Format('date'[Date], "MMM")

Hope this will solve your problem.

[powerbiexpert22]

Hi @shafiz_p , sorry,  my mistake, thanks a lot for your help

[shafiz_p]

@powerbiexpert22  You are welcome. If this solved your problem, please accept it as a solution, so that others can find this easily.