Line chart with two different dates

[lucie_raboch]

Hi all,

I have the following data sets:

Date - date format

CP_Date - date format

Name - string

Metric - integer number

And using Date, Name and Metric I have created the below Line chart, nothing special.

Now I need to include CP_DATE into line chart, so the chart would look like this:

It is possible to create points or vertical lines based on CP_DATE? So basicaly we will have two different dates in line chart?

Thank you so much for your help.

I'm attaching pbx file:

https://drive.google.com/file/d/1gev9T2o3TtpKpcxUfqRMjqSSAkyB1sF4/view?usp=drive_link

[lbendlin · Accepted solution]

like that?

[lucie_raboch · Accepted solution]

this is solution, thank you

[lbendlin · Accepted solution]

like that?

[lucie_raboch]

Hello,

Any update on this.

[lucie_raboch]

hi v-vogua,

CP_DATE is not static, I have attached a pbi file in the previous post so you can see what I need, thank you

[lbendlin]

Your CP Date examples are outside of the range of the regular dates.

[lucie_raboch]

I'm sorry, this is better example:

https://drive.google.com/file/d/1gev9T2o3TtpKpcxUfqRMjqSSAkyB1sF4/view?usp=drive_link

[v-yohua-msft]

Hi, @lucie_raboch 

Create a view and find the Reference line in format

Here is my preview:

For more details about it, you can check the link below:

Use the Analytics pane in Power BI Desktop - Power BI | Microsoft Learn

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...