Column chart

[Anonymous]

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

[GilbertQ]

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 · Accepted solution]

Thanks a Lot !