Showing results for 
Search instead for 
Did you mean: 
New Member

Trouble Adding Additional Columns in Matrix

Hi there,

I'm currently working on a number of matrix visuals in my dashboards that utilize a number of columns originating from multiple tables (Actual Spending, Forecasted Spending, and a Numeric Code table where my category, subcategory, and code come from). In the matrix fields, in rows I have Category, Subcategory, and Code; in column I have Months (worth noting that the page also has a month and a year slicer); and in values I have Amount and Quantity (two separate columns coming from the Actual Spending table). In my Actual Spending table, I have a current Year-to-Date spending column and from my Forecast table, a linear projection value that I would like to place in the matrix as columns following the (selected) months.


This has posed to be an issue for me, as the YTD and linear projection records have a date value of 12/1/2019. I have tried the word-wrap option for my column headers which was unsuccessful for a number of reasons (Dec. had to be selected and would stay visible, regardless of hiding Amt/Qty headers; also had to have the latest mo. selected instead of YTD remaining static). I have also considered using column subtotals (to imitate YTD) but that doesn't suffice, either. This is a roadblock that I've been stumped on for quite some time now and any guidance on how to achieve this would be immensely appreciated. Attached is a photo of my desired result, in which I have blocked out the Dec. with a white text box.




It is quite problematic to understand your issue.

Could you please provide more clear explanation (with steps) and several screenshots with data (use fake data if is is confidential).


Kind Regards,

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals

Helpful resources

PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Top Kudoed Authors