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.
Hi everyone , i have created line and clusterd column graphs based on the data. Now i want column based on the total value. see data set below samples
i converted in to this its working .i want month variation column for total looks like
i want to show all the values in total column bar like below
how to add the total colulmn already added plant value
please any idea .
Solved! Go to Solution.
I think it'd be better if you Unpivot the table in Power Query and use the new format in the report.
Otherwise, try to add and use a measure as below:
Measure = sum([overstock consumption])+Sum([new materials]).....+sum([last column])
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Hi @THENNA_41
Is the data table in the Power BI like the first image you shared?
Appreciate your Kudos!!
I think it'd be better if you Unpivot the table in Power Query and use the new format in the report.
Otherwise, try to add and use a measure as below:
Measure = sum([overstock consumption])+Sum([new materials]).....+sum([last column])
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
User | Count |
---|---|
52 | |
51 | |
20 | |
17 | |
16 |
User | Count |
---|---|
113 | |
45 | |
44 | |
28 | |
22 |