Trouble Adding Additional Columns in Matrix

amtol — Mon, 19 Aug 2019 01:55:26 GMT

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.

Re: Trouble Adding Additional Columns in Matrix

v-evelk — Fri, 23 Aug 2019 15:31:52 GMT

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

topic Re: Trouble Adding Additional Columns in Matrix in Custom Visuals Development Discussion

Trouble Adding Additional Columns in Matrix

Re: Trouble Adding Additional Columns in Matrix