Forum Discussion

Balta-expertise's avatar
Balta-expertise
Regular Visitor
5 years ago
Solved

Line Chart - 2 color in the same line

Hi Everyone,   I've an issue and I'm out of the solution   I've two data base : - The first is for the real financial data ; - The second is for the forecasted financial data ; => both base ar...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Balta-expertise,

    You can use measure expression to replace raw value fields and add if statement on these values to skip calculation on speed ranges After these steps, power bi will auto-hidden these blank parts.

    Regards,

    Xiaoxin Sheng

Balta-expertise's avatar
Balta-expertise
Regular Visitor
5 years ago

hi amitchandak ,

Thank you for your answer. What represent the "Target" on your SUM function ? When I try with 2 measures, they are superimposed. I try to add a filter on the calculate function but the lines doesn't stop and continued until the end of the year:

 

Thank you very much fr your help. It's is more easy, I can share the PBIX File via dropbox ?

Jules

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Balta-expertise,

You can use measure expression to replace raw value fields and add if statement on these values to skip calculation on speed ranges After these steps, power bi will auto-hidden these blank parts.

Regards,

Xiaoxin Sheng