How to show trends as a percent of row total on chart with two category axes.

[GLIDO]

Hello Users, 

Stuck with some serious stuff, 

Actually I have the following data in the form of a matrix ,

As we can see, the data shows the trends of a dimension "DPD Bucket Dtls" by different months. The values in this matrix have been set as row totals. 

Now I am required to make a line chart of them, where both "Months" and "DPD Bucket Dtls" will be on category axis and percentage on the value axis. 

While trying to get it done , I ended up like this, 

Which is showing  a.)Grand total percentage instead of row total and b.) the category axis looks ugly. 

Can anyone help me with the issues.

Quite Urgent, 

Thanks in Advance 

Regards

Nilesh Kumar

[v-lili6-msft]

hi, @GLIDO

After my research, you could do these as below:

a) you could use All Function to add a measure as below instead of show value of Percent of grand total

Measure = CALCULATE(SUM(Table1[Qty]))/CALCULATE(SUM(Table1[Qty]),ALL(Table1[DPD]))

b)you could sort by measure desc as below:

Result:

Best Regards,

Lin