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 Team,
Can somebody to know how do i need to arrange table/data in pbi to be able to construct something like below image?
Image is from a stacked column in Excel and I'm using the table numbers to fed the graph. Consider that:
Sorry and thanks,
,
@Luis_u534485 , Create a Calculation group.
You need to have one or more measures for each stack row (Make sure the Measure in white color should added before )
Now go to the calculation group table and add a column that will group measures to appear on each row of stacked and then use that group and calculation group as the Axis in the visual
Add Manually | |||
Calculation Item | Group | Color in Visual | Measure copied in step |
Measure 1 | Budytd/ytg | ||
Measure 2 | Budytd/ytg | Meausre 2 | |
Measure 3 | ACTKS | White | |
Measure 4 | ACTKS | ||
Measure 5 | YTDKS | White | Measure 4 |
Measure 6 | YTDKS | ||
Measure 7 | OOrdersKS | ||
Measure 8 | OOrdersKS | ||
Measure 9 | FY CY KS | ||
Measure 10 | CY Plan KS |
User | Count |
---|---|
88 | |
72 | |
68 | |
64 | |
54 |
User | Count |
---|---|
98 | |
91 | |
74 | |
68 | |
63 |