Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
57 | |
21 | |
19 | |
16 | |
16 |
User | Count |
---|---|
87 | |
77 | |
52 | |
37 | |
21 |