Forum Discussion
Anonymous
3 years agoNot applicable
Line graph doesnt lands on zero
Hello,
I need help on my line chart, it doenst land on zero i read some articles here that i should add + 0 on the measure and check the show items with no data but those two doesnt seem to work.
My Y axis is on text so i count them by using countrows
CTQ count = CALCULATE(COUNT('CA Raw'[KL / Onshore CTQ/Characteristic]) + 0)
The thing is i wanted it to look like this
Appreciate all your comments thanks!
2 Replies
- vanessafvgCommunity Champion
try
CTQ count =
IF (
ISBLANK ( COUNT ( 'CA Raw'[KL / Onshore CTQ/Characteristic] ) ),
0,
COUNT ( 'CA Raw'[KL / Onshore CTQ/Characteristic] )
)- AnonymousNot applicable
Hello, it still doesnt line at zero 😞