[Line & Clustered Column Chart] Displays same value going up and down instead of a straight line.

[ptphuy]

Hello everyone, 

I have 2 measures which calculate revenue and target. For the target, it's the same value (146177415) for every day. Therefore, it's supposed to be displayed a straight line. However, it displayed like the screenshot below. Anyone had this issue as well? Please help me. Thank you so much.

[dilumd · Accepted solution]

Hi

without looking at your data and relationships it's bit difficult to tell what’s going on here (Just check your table relationships again), but if your target revenue is a constant number you can use constant line feature in the analytics section.

Please refer the below,

 

[ptphuy]

Thank you @dilumd, I solved my issue with your recommendation 🙂