Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! 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 = 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
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.
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
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |