Forum Discussion
Calculated Measure to show in Column
I am new to Power BI and apologize in advance. I've done some research and reached out to the consultant; however, it seems it may not be possible. I had to create a measure for GROSS PROFIT as below, add to the matrix, and turn on the "Show in Row" option because I could not get it to show in a regular matrix as a row. Then I had to create the same measures for the prior year and the same for variances. I also realized I couldn't get the current year, prior year, and variances in the same matrix, so I created 3 matrices and put them side by side.
Is there a better way to accomplish this so I have the current year, prior year, and the variances for the P&L categories in one matrix? Thanks for your help.
3 Replies
- parry2k
Super User
rhayami you should be able to use all 3 measures in the same matrix, just drop the measure on the values section, if you have turned on show on rows, all 3 will show on rows.
✨ Follow us on LinkedIn
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Yes, they will be in the same matrix, but all stacked in 1 row, which is not the ideal outcome we are looking for. The current year's figures in 1 colum, prior year's figures in the column next to it, then the variances in the last column.
- parry2k
if you have show on rows turned on, it will be on rows, not on columns. Looks like I'm not following your question.
