cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
amtol
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.

Forum.png

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.

1 REPLY 1
v-evelk
Microsoft
Microsoft

Hi,

 

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
pbicvsupport@microsoft.com

Helpful resources

Announcements
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.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Urdu Hindi D365 Bootcamp 768x460.png

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Top Solution Authors
Top Kudoed Authors