Forum Discussion

shantupm5's avatar
shantupm5
Icon for Helper III rankHelper III
3 years ago

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 ...
Need Help
Show and Tell
Tips and Tricks
DOLEARY85's avatar
DOLEARY85
Icon for Resident Rockstar rankResident Rockstar
3 years ago

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 👍