Forum Discussion
Rohithdhruva22
3 years agoRegular Visitor
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_Sales | Earnings |
| 0 | 0 |
| 1 | 425 |
| 2 | 850 |
| 3 | 1275 |
| 4 | 1700 |
| 5 | 2125 |
| 6 | 2550 |
| 7 | 2975 |
| 8 | 3400 |
| 9 | 3825 |
| 10 | 4250 |
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
like this?
1 Reply
- lbendlin
Super User