Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, I'm trying to figure out how to visualize two colums by placing the total value of one onto the total value of the other column as a whole. Like below:
When I add the sum of the columns to the visual they add both together for a total of 2000KG where I want it to show as in the above picture. Please help, thanks.
Solved! Go to Solution.
First, create new columns to add the actuals and contracted columns
total actuals = SUM('Table'[actuals])
total contracted = SUM('Table'[contracted])
Next, select stacked bar chart and check New Columns
The final visual is as follows
If you're still having problems, provide some dummy data and the desired outcome. It is best presented in the form of a table.
Best Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
@v-nuoc-msft has already proposed a solution, but I'll add my two cents here since I've understood the task differently - in my understanding, the second bar should be still 66,6% but captioned differently.
I guess you need to apply custom captions here but unfortunatelly PBI doesn't allow to place them outside the bar.
First, create those captions via measures:
Caption 1 = SUM ( 'Table'[Actuals] )
Caption 2 = SUM ('Table'[Actuals] ) + SUM ('Table'[Contracted] )
And then apply via the menu @v-nuoc-msft already mentioned:
Best Regards,
Alexander
Hi,
@v-nuoc-msft has already proposed a solution, but I'll add my two cents here since I've understood the task differently - in my understanding, the second bar should be still 66,6% but captioned differently.
I guess you need to apply custom captions here but unfortunatelly PBI doesn't allow to place them outside the bar.
First, create those captions via measures:
Caption 1 = SUM ( 'Table'[Actuals] )
Caption 2 = SUM ('Table'[Actuals] ) + SUM ('Table'[Contracted] )
And then apply via the menu @v-nuoc-msft already mentioned:
Best Regards,
Alexander
First, create new columns to add the actuals and contracted columns
total actuals = SUM('Table'[actuals])
total contracted = SUM('Table'[contracted])
Next, select stacked bar chart and check New Columns
The final visual is as follows
If you're still having problems, provide some dummy data and the desired outcome. It is best presented in the form of a table.
Best Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.