Matrix Configuration - add a goal measure column

[AbigailCole]

Hello all,

I am attempting to re-create this table in power bi:

Where the KPI's are measures used in the power bi. I was able to create a matrix with the months and the YTD:

But how does one add a goal column to this matrix? I found a similar question on the forum, however they *replaced* the total column with the goal column, and I'm hoping to do both. This is the current measure I use for the goal column:

Monthly Matrix Ratio 1 = IF(

                                                HASONEVALUE('Calendar'[Month]),

                                                                 [Ratio 1],

                                                                 AVERAGE('PLANT LIST'[RATIO_1_TARGET])

                                             )

However then I get a matrix that looks like this:

Any way to have my cake and eat it too? aka have a YTD and Goal column in a matrix? Or does this really have to be in seperate visuals?

Thank you all,

Abbey

[Anonymous · Accepted solution]

Hi @AbigailCole ,

Due to its design, there is no way for PBI Desktop to directly display such a matrix. But you can take the following alternative.
1. First you need to create two measures [Total] and [Goal] and then you need to place them in the Value field of the matrix.

2. Then manually adjust the column widths to hide the Total and Goal values under the month and keep only the data you want to show.

3. Finally search for "text wrap" under the [Format your visual] pane and close it.

4.Then the result is as follows.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[AbigailCole]

Thank you!! I appreciate this work around!