Forum Discussion
Remove empty row column headings from Matrix table Chart
- 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
4 Replies
- NaveenGandhiMemorable Member
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!!- Johnsmith23Frequent Visitor
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.
- NaveenGandhiMemorable Member
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!