cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Anonymous
Not applicable

## Need help in finding ratio per month and plot the month wise trend.

I have two tables, 1st table which gives month wise waste weight for the range of products and 2nd table contains the tonnage produced per month. I would like to find the % waste per month against the tonnage produced and plot the trend month wise.

For example:

Total waste weight in Jan 2021 is 5624kg & Tonnage produced in Jan 1386000 .

% waste for Jan=  5.624 tons / 1386 tons = 0.40%, Like this need for each month and plot the trend month wise.

I am new to powerbi, support will help me.

 Table1 waste weight Product Month Year weight Blackmix Jan 2021 3158 labscrap Jan 2021 1104 carbonblack Jan 2021 862 Gpmix Jan 2021 170 Elastomer Jan 2021 0 Blocs Jan 2021 18 BU Jan 2021 73 Chemical Jan 2021 0 silica Jan 2021 239 Blackmix Feb 2021 2552.4 labscrap Feb 2021 1303.6 carbonblack Feb 2021 1249 Gpmix Feb 2021 1395 Elastomer Feb 2021 109 Blocs Feb 2021 14 BU Feb 2021 55 Chemical Feb 2021 8 silica Feb 2021 4 Blackmix Mar 2021 1832.5 labscrap Mar 2021 1216.5 carbonblack Mar 2021 1547 Gpmix Mar 2021 1126 Elastomer Mar 2021 704 Blocs Mar 2021 237 BU Mar 2021 115 Chemical Mar 2021 286 silica Mar 2021 7 Blackmix Apr 2021 3390.4 labscrap Apr 2021 1311.5 carbonblack Apr 2021 1224 Gpmix Apr 2021 414 Elastomer Apr 2021 199 Blocs Apr 2021 9 BU Apr 2021 111 Chemical Apr 2021 26 silica Apr 2021 18
 Table 2 tonnage Month Weight Jan 1386000 Feb 1726000 Mar 2079000 apr 2205000 may 1436000 Jun 1637000 Jul 1760000 Aug 2200000

2 ACCEPTED SOLUTIONS
Super User

Hi @Anonymous

Please change the Cross filter Direction from Single to Both [relation between those 2 tables]and check the chart again.

Community Support

@Anonymous

According to this function:

Measure =

DIVIDE(SUM('Table1'[weight]),SUM('Table2'[Weight]))

In the clustered column chart, do you use the column [Month] in Table1 instead of the column [Month] in Table2. Using the column [Month] of different tables will produce different results:

Best Regards,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

8 REPLIES 8
Community Support

@Anonymous

According to this function:

Measure =

DIVIDE(SUM('Table1'[weight]),SUM('Table2'[Weight]))

In the clustered column chart, do you use the column [Month] in Table1 instead of the column [Month] in Table2. Using the column [Month] of different tables will produce different results:

Best Regards,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Anonymous
Not applicable

@VahidDM Hi..

I got the table now.

But when i put that in clustered coloumn chart for the month wise trend. the value changes.

Any mistake i am making. Kindly guide.

Super User

hi @Anonymous

hqve you changed the Cross filter Direction from Single to Both [relation between those 2 tables] and check the chart again.

Super User

Hi @Anonymous

Please change the Cross filter Direction from Single to Both [relation between those 2 tables]and check the chart again.

Super User

Hi @Anonymous

Then try this measure:

``````% waste =
SUM ( Table1[weight] ) / SUM ( 'Table 2'[Weight] )``````

Use this measure and Month column to create a table like this:

Anonymous
Not applicable

I tried creating a table, whereas the % waste ( %IQP  ) is displaying 0.

am i making any mistake ?

Super User

Hi @Anonymous

Change the type of %IQP value to the percentage.

Anonymous
Not applicable

and also pls help me to make a Month wise %Waste trend chart.