Displaying the exact numbers instead of calculations.

[anabianco09]

Hi all,

I am trying to display a constant line throughout a timeline, but on specific dates, the value would be different....

On the picture it always has a value of 6. However I want to show for the week of Christmas, for example, this value to be 3. 

I created a conditional column with all the different values (whole numbers) I want, but when I display, it shows the sum, median, or any other calculation than the exact number:

How can I display the numbers instead of the calculation?

Is there a way to create a conditional measure?

Thank you!

[darylmitchell]

You could always not use a constant line but just a bar and line chart.
Then base  the line on whatever you want your constant to be and call it "Constant"

[anabianco09]

That's what I am doing.

WHat do you mean by base the line?

It's a column (whole number), but I dont want any calculations on it