Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Remove Gap Between Lines in Line Chart

Hi. I have a few measures represented by lines on the chart but I would like to remove the gap in between. Is this possible?

Appreciate any help please. Thanks.


Sample pbix attached
https://drive.google.com/file/d/1I9C-6Lw8IV6G1JbiNizcyfa06ROevmVi/view?usp=sharing

 

 

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

    The two measures represent the different values. Cannot remove the gap.

    Maybe you can write the two measures into a measure or column.

    valuecolumn = IF([Actual Value]=BLANK(),'final_ccc_forecast for graph'[Forecast Value],[Actual Value])

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

    The two measures represent the different values. Cannot remove the gap.

    Maybe you can write the two measures into a measure or column.

    valuecolumn = IF([Actual Value]=BLANK(),'final_ccc_forecast for graph'[Forecast Value],[Actual Value])

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Anonymous thank you, that works.