Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Column chart

Hi community, 

 

I have created a column chart for 7 sequencial stages in the sales process and the associated value for each stage.  Currently the column chart resizes and doesnt show certain stages which has no value in it when i apply filter based on sales person. 

 

I would like the x axis to remain the same without turncating stages which are blank 

 

Can anyone suggest a solution pls? 

 

Regards,

Hareesh

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Thanks a Lot !

2 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    4 years ago

    Hi Anonymous 


    Create a new measure with the following below, what this will do is when it is blank it will return a zero

    My New Measure = IF(ISBLANK([Current Measure]),0,[Current Measure])

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thanks a Lot !