line graph for percentage calculation is not displaying correctly in Line and clustered column chart

[dinesharivalaga]

Hi All ,

I have a scenario to generate values and percentage in same graph (hence used line and clustered column chart) .

X axis has some age bucket (days) , Y axis has amount , and Line should be % of each bars .

Here all working fine if i used the data from master source file .

But in X axis , the days are not in order as attached below ..

See here the days should start from 1-30 , 31-60 and so on ...

But if we sort with age bucket (days) then it starts from 121 , for this case i have created a new table to make this order correctly like below ..

After that i can able to sort the days in correct order but once i applied this , the % value changed into 100% for all bars .

Now days (X axis) fixed and sorted in expected order but % value changed . I don't know why it happening when i applied relational table column into this graph ..

Can you help to fix this ?

[amitchandak · Accepted solution]

@dinesharivalaga , If it is % of the total, you need a measure like

% = divide([Measure], calculate([Measure], allselected()) )

And you should use combo visual, Line, and column Bar visual. Do not use analytics pane for this

[dinesharivalaga]

Hi @amitchandak  , thanks for your response ..

will try this measure and i don't understand this "And you should use combo visual, Line, and column Bar visual. Do not use analytics pane for this" ..

Can you elaborate a bit?