Hardcode Custom Row in PowerBI Matrix

[agram]

Hi all, so I have a matrix in PowerBI that looks as follows: 

I am wondering if it possible to create a custom row in the top row of the table that would look something like this: 

The Budget and Forecast exist in my data currently but the only way I have found to add them adds them as another column rather tahn another row on top of the data which is what I am after. I am wondering if it is possible to link my data into a custom row like this and if not is there a possibility to just hardcode the data in and I can enter it myself.

[Anonymous · Accepted solution]

Hi All
Firstly Greg_Deckler thank you for your solution!
And @agram ,after all this time, have you solved the problem you are experiencing, if you are still experiencing problems with the new table, I have written the DAX based on your example data, I hope it can help you! 

NewTable = 
UNION(
    SELECTCOLUMNS(
        'Table',
        "Month", [Month],
        "Week", [Week],
        "# day", [# day],
        "COND Ratio", [COND Ratio],
        "FIELD", [FIELD]
    ),
    ROW(
        "Month", "April",
        "Week", "Budget",
        "# day", BLANK(),
        "COND Ratio", 15,  
        "FIELD", 20 
    ),
    ROW(
        "Month", "April",
        "Week", "Forecast",
        "# day", BLANK(),
        "COND Ratio", 16,  
        "FIELD", 21 
    )

)

If you have any other questions, you can check out the PBIX file I uploaded, and I'd be honoured if my answer solves your problem!

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@agram Well, there's a way but it's really ugly. The New Hotness (Custom Matrix Hierarchy) - Microsoft Fabric Community

[agram]

Just read your write up.. Looks exactly like what I am looking for! Just wondering though, in your write up you create new columns, how am I able to create new rows with a hierarchy?

[Greg_Deckler]

@agram It should be the same technique but you would use the disconnected table for the rows instead of the columns. Or, you may have to use a disconnected table for both the rows and the columns. If you post sample data as text I might have time to look at it more in-depth.