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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years 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.

agram's avatar
agram
Frequent Visitor
2 years ago

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's avatar
    Greg_Deckler
    Community Champion
    2 years ago

    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.