Remove empty row column headings from Matrix table Chart

[Johnsmith23]

• Hi all
  I'm stuck with this, I wanna remove the empty column headings from( July to dec) in the martrix table chart.
• Can someone help me up

 

 

 

  

[NaveenGandhi]

Hello @Johnsmith23 

Unfortunately we can't remove the blank rows when two metric is involved, Below table visual will make things clear for you.

Since forecast is availble for months where sales is not avaible, it won't be possible just to neglect blank sales month as the month is common for both sales and forecast. The best way would be to show 0 instead of blank.

Let me know if this helps and if you have any question.

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

[Johnsmith23]

Thanks for response @NaveenGandhi 

https://community.fabric.microsoft.com/t5/Desktop/hiding-columns-in-Matrix/m-p/544289

Could you check out this reference

Is it possible to do it this way.

[NaveenGandhi]

@Johnsmith23 

Can you let me know what scenario column mean in your table and also it would be great if you can provide a SS of scenario column for whole of 2023!

[Johnsmith23]

@NaveenGandhi 

Year is th only relationship between Matrix Table and Financial sales table (its a many to many relationship) I was using Year and month from financial sales tabel. I have year and months for almost all the table but there is no way for setting up the relationship.