Forum Discussion

mur2za's avatar
mur2za
Frequent Visitor
10 years ago
Solved

Calculate and Plot Percent Mix

Hey guys, I am trying to create a line and column graph that plots sales by product (column) and the percentage of total sales of each product (line). The first part is obviously simple - I can't fig...
Need Help
  • Sean's avatar
    Sean
    10 years ago

    mur2za Yes to get the overall total at ALL levels - don't specify a column!

     

    Look at the picture and you'll see what I mean.

     

    Your function did exactly what you asked it to do => gave you the overall total but only at the Catgeory Level.

     

     

Baskar's avatar
Baskar
Icon for Resident Rockstar rankResident Rockstar
10 years ago

Hi Mur2za,

 

Cool buddy we can do.

 

1. Drag the sales in column from here u will get the column , i think no issue for you on this, okay go

 

2. Again Drag the same sales in line ,

   a. from the sales in line chart click the "Down Arrow" then u can see the option like "Quick Calc" click that one.

 

This is the new feature added in power BI latest edition. It will help to solve your prob.

 

 

From there choose "Percent of grand total" from "Show value as" box

 

Hope it will help u, if not let me know