Forum Discussion
shantupm5
3 years agoHelper III
column chart with Percent split
Hello I have a data field which is sum of Manual orders and Electronic Orders, Total Orders = Manual Order + Electronics Orders Please can you guide how to i show a column chart which ...
DOLEARY85
3 years agoResident Rockstar
Hi,
it would be more helpful to know more about the output but you could try dividing the individual maunual and electronic fields against the total to get 2 measures then adding them both to a chart to get the split:
Electronic orders = calculate(sum('Table'[Electronic Order]))/[Total Order]
manual orders = calculate(sum('Table'[Manual Order]))/[Total Order]
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍