Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

  • vanessafvg's avatar
    vanessafvg
    Community Champion

    try

     

    CTQ count =
    IF (
    ISBLANK ( COUNT ( 'CA Raw'[KL / Onshore CTQ/Characteristic] ) ),
    0,
    COUNT ( 'CA Raw'[KL / Onshore CTQ/Characteristic] )
    )

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hello, it still doesnt line at zero 😞