topic Line chart with two different dates in DAX Commands and Tips

Line chart with two different dates

lucie_raboch — Sun, 23 Jun 2024 11:43:22 GMT

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

Re: Line chart with two different dates

lbendlin — Tue, 18 Jun 2024 23:56:56 GMT

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-Forum/ba-p/963216

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/1447523

Re: Line chart with two different dates

Anonymous — Wed, 19 Jun 2024 02:37:47 GMT

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.

Re: Line chart with two different dates

lucie_raboch — Sat, 22 Jun 2024 05:58:55 GMT

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

Re: Line chart with two different dates

lbendlin — Sat, 22 Jun 2024 15:46:51 GMT

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

Re: Line chart with two different dates

lucie_raboch — Sun, 23 Jun 2024 11:41:26 GMT

I'm sorry, this is better example:

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

Re: Line chart with two different dates

lucie_raboch — Fri, 28 Jun 2024 04:57:07 GMT

Hello,

Any update on this.

Re: Line chart with two different dates

lbendlin — Fri, 28 Jun 2024 16:37:55 GMT

like that?

Re: Line chart with two different dates

lucie_raboch — Tue, 02 Jul 2024 11:49:29 GMT

this is solution, thank you