Non Repeating Matrix Columns

[trevrobwhite2]

Is it possible to add a non-repeating column to a matrix?

I need to add a static column to the start of the data and about 3 columns to the end, I tried with this DAX, it does actually work but attaches itself under my date column, which is fine for the first month, but all subsequent months have the same column which contains no data.

I was hoping there was a way to convince Power BI to hide these columns which are completely empty or if there is another way to format the data?  Maybe in a simular way as creating multiple grand totals?

Baseline Matrix = 
IF (
    ISINSCOPE('Global DateTable'[Invoice Date Month-Year]) && 
    SELECTEDVALUE('Global DateTable'[Invoice Date Month-Year]) = "Dec-24",
    [Baseline Charge],
    BLANK()
)

Sadly I cannot use a table because it contains drills.

[danextian]

Hi @trevrobwhite2 

If you want to add extra columns to your matrix, for example a percentage column before the actual values per date, then the column values must exist physically in a disconnected table. Adding two or more fields to the column tile will only create a hierarchy.

You wil need to create another measure that will reference the value in the column from this disconnected table.

Please see the attached sample pbix.

If you dont want this approach, there is a pretty good subscription-based custom visual from inforiver-

https://appsource.microsoft.com/en-us/product/power-bi-visuals/xviz.inforiver-premium?tab=overview 

[trevrobwhite2]

I cannot seem to download this file, I waited until after the maintenance but still doesn't work

[Ritaf1983]

Hi @trevrobwhite2 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[trevrobwhite2]

This is what I'm trying to create:

Invoice Month	Baseline Budget	Jan-25	Feb-25	Mar-25	Q1 Budget	Q1 Acutal	Q1 Difference
Department 1	$565.00	$600.00	$400.00	$600.00	$1,695.00	$1,600.00	($95.00)
--- Sub Dept	$100.00	$100.00	$200.00	$200.00	$300.00	$500.00	$200.00
--- Sub Dept 2	$465.00	$500.00	$200.00	$400.00	$1,395.00	$1,100.00	($295.00)
Department 2	$955.00	$236.00	$200.00	$332.00	$2,865.00	$768.00	($2,097.00)
Department 3	$6.00	$655.00	$100.00	$11.00	$18.00	$766.00	$748.00
Department 4	$55.00	$64.00	$300.00	$44.00	$165.00	$408.00	$243.00
Totals	$2,146.00	$2,155.00	$1,400.00	$1,587.00	$6,438.00	$5,142.00	($1,296.00)

So there is a static start column and add the end 3 columns, ideally these would then get repeated for each quarter, my field well is shown below, if I add an additional column under the date it then gets included even if I force the data blank.

Downloads aren't working on the forum since the upgrade, but I created another table and foced my columns in that seemed to work however when the data is drilled the sum stops working and I'm unsure how to handle the additional months, I started looking at calculation groups but haven't got it working yet

Thanks in advance