Forum Discussion

peteralberts's avatar
peteralberts
New Member
5 years ago
Solved

Problem with line chart

I have 2 reports with a "two line" line chart visual. 1. PowerBI report, with excel import data for a forcast 12 month values, and an actual YTD values up to the current month 2. Exact same report ...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi peteralberts ,

     

    I couldn't reproduct your problem, the following image is the line chart I created with import and direct query mode, both of which are consistent. 

     

     

    I think you need use a measure, like this:

     

    Measure = 
IF(
    SUM('Table'[Resolved Cumulative]) = 0,
    BLANK(), 
    SUM('Table'[Resolved Cumulative])
)

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

    Best Regards,
    Winniz

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

v-kkf-msft's avatar
v-kkf-msft
Community Support
4 years ago

Hi peteralberts ,

 

I couldn't reproduct your problem, the following image is the line chart I created with import and direct query mode, both of which are consistent. 

 

 

I think you need use a measure, like this:

 

Measure = 
IF(
    SUM('Table'[Resolved Cumulative]) = 0,
    BLANK(), 
    SUM('Table'[Resolved Cumulative])
)

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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