Line chart with missing value

[ADP007]

Hi all,

I have a line chart with 3 metrics.

Two metrics (Growth and Individual) represent a curve

The Individual point is an indication of a specific moment that occurs at 9.1 contacts.

My question is:

• Can the two blue lines be continuous (no break between 9 contacts and 10 contacts) ?
• Can I get rid of the 9.1 in the X-Xaxis (contacts)

Below is my data used

Many thanks in advance

D.

Contacts	Individual	Growth	Individual-Points
0	1.528716301	0
1	2.451718549	0.923002247
2	3.868910809	2.340194508
3	5.958488009	4.429771707
4	8.862417829	7.333701527
5	12.58284838	11.05413208
6	16.88261508	15.35389878
7	21.29800479	19.76928849
8	25.31467164	23.78595534
9	28.58532245	27.05660615
9.1			28.86574326
10	31.01651328	29.48779698
11	32.70400268	31.17528638
12	33.82032617	32.29160987
13	34.53551258	33.00679628
14	34.98433996	33.45562365
15	35.26236832	33.73365202
16	35.43320852	33.90449222
17	35.53766411	34.00894781
18	35.60133658	34.07262028
19	35.64007712	34.11136082
20	35.66362159	34.13490529

[parry2k · Accepted solution]

@ADP007 yes you can achieve bar, use Line and Clustered column chart

✨ Follow us on LinkedIn and  to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

[ADP007]

Thanks a lot @parry2k 

[ADP007]

Hi @amitchandak 

Yes it does work thanks. Just a pity I can't see all the X values 0,1,2,3 instead of 0,5,10 etc...

Do you think it's possible somehow to have a vertical line at 28.9? Like the image below (see red arrow)

Thanks

D.

[amitchandak]

@ADP007 , I doubt we have any control when continuous values are displayed

[amitchandak]

@ADP007 , I think if the axis type is continuous, it can work. Supported for numeric and date columns