Forum Discussion

Rohithdhruva22's avatar
Rohithdhruva22
Regular Visitor
3 years ago
Solved

Unable to format Line Chart as per the requirement

I have a requirement to format the graph visual in such a way , I need to show two different colours on a same line with respect to a condition ( The values that are in range btwn 0 to 4 need to be differentiated from rest of the range ) i can able to show the two different colors in same line with using of below measures

orange_line = SUMX(FILTER('Sheet1',Sheet1[Projected_Sales]<=3),'Sheet1'[Earnings])
Blue_line = SUMX(FILTER('Sheet1',Sheet1[Projected_Sales]>=3),Sheet1[Earnings])
but i can able to see the two earning values when i was overhere on sales 3 but i want to see the only single earnings value when i was overhere on value 3,

 


Projected_SalesEarnings
00
1425
2850
31275
41700
52125
62550
72975
83400
93825
104250

 

if i was using (<3)and >3 i was getting spece b/w the two lines

can anyone please help on this to show only single earnings velues for 3 without any space b/w the two lines