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 show the Percentage split of Manual Orders & electronic orders

 

Regards

Prashanth

 

Need Help
Show and Tell
Tips and Tricks

2 Replies

  • 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 👍