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 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.

 

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.

4 Replies

    • 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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.