Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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:
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
Solved! Go to 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.
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.
Thank you!! I appreciate this work around!
User | Count |
---|---|
86 | |
82 | |
68 | |
67 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |