Forum Discussion
Solved
Condition Column not giving the right values
Hello All, I have revenue table which has a coImn for projected revenue and actual revenue,I'm trying to comeup with a line chart where I have only one line which would be solid till the current ...
To do something like this you have to have 2 lines in a chart. One will be the real revenue and the other will be the projected one. Then you'll be able to set the attributes of each line separately. With one line and one measure it's not achievable.
So, create 2 measures. One with the actual revenue and the other with a projection and put in one line chart. Customize both lines.
Best
D
Hi Anand,
Your approach to writing Dax was correct. I tried it by myself and found it working.
Result:
Result_Table
Dax:
combined =
IF (
'Table'[Monthly Revenue] = 0,
'Table'[Proj. Rev],
'Table'[Monthly Revenue]
)
Final Visual:
trend_visual
Regards,
Kaushlendra Mishra
Linkedin-www.linkedin.com/in/kaushlendra-mishra-49627310