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
Go to 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 =
SUM ( 'Table'[Answers] );
CALCULATE ( SUM ( 'Table'[Answers] ); ALL ( 'Table'[Category] ) )
Add date to the axis, the measure to the value and category as legend.
View solution in original post
@sturlaws Thank you ,it worked !And thank you for feedback.
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.
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!