Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Line Chart showing gaps where blank data

Hi, 

 

I have a line chart whereby I have gaps in the line where the value on my x-axis is blank.

 

I'm assuming that I can get around this by amending my current logic, or maybe I can make a change on the line chart, but not really sure how to do this. Any idea please?

 

I have added my logic below on the off chance a change there is needed to get this to work?

 

% =
var _value1 =
CALCULATE(DISTINCTCOUNT(FACT_vols[mort_no]), FACT_vols[new_in] = "Y")
var _value2 =
CALCULATE(DISTINCTCOUNT(FACT_vols[comp_number]), FACT_vols[dept_Number] = 0)
return
divide (_value1, _value2)

 

 

Need Help
  • VijayP's avatar
    VijayP
    4 years ago

    Anonymous 

    To Avoid Blanks in chart , just removing that particular item from chart may help

    IF(ISBLANK(Measure),BLANK(),Measure)

    Try using this may help you get rid of the blanks in Line!

2 Replies

  • VijayP's avatar
    VijayP
    Community Champion
    4 years ago

    Anonymous 

    To Avoid Blanks in chart , just removing that particular item from chart may help

    IF(ISBLANK(Measure),BLANK(),Measure)

    Try using this may help you get rid of the blanks in Line!

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    4 years ago

    Hi Anonymous ,

     

    Whether the advice given by VijayP  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly.

     

    If not, please point it out. Looking forward to your feedback.

     

    Best Regards,
    Henry