Forum Discussion
Hardcode Custom Row in PowerBI Matrix
- Anonymous1 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 ShenIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
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.