Create line graph based on % of Row total

[Anonymous]

Hello,

I want to create a graph that is based on categories within one column.

While I can create a table based on % of row total --I cannot do the same with line graph

Basing graph on pure # of records is visibly misleading.

Please see the example in Excel below

[Anonymous]

For sake of clearence I decided to remove some content from this question, so hopefully other users with the same question will find an answer here.

[sturlaws · Accepted solution]

Hi @Anonymous ,

It is not clear to me what you are trying to do. And it is further confusing that the data sample you provide, does not correspond to to your excel snapshots.

But if you are trying to do what I think you are trying to do, use dax code like this:

Percent of date total =
DIVIDE (
    SUM ( 'Table'[Answers] );
    CALCULATE ( SUM ( 'Table'[Answers] ); ALL ( 'Table'[Category] ) )
)

Add date to the axis, the measure to the value and category as legend.

Cheers,

Sturla

[Anonymous]

@sturlaws Thank you ,it worked !
And thank you for feedback.