Forum Discussion

agram's avatar
agram
Frequent Visitor
2 years ago
Solved

Hardcode Custom Row in PowerBI Matrix

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 ...
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.