Forum Discussion
Line chart with two different dates
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
like that?
this is solution, thank you
8 Replies
like that?
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/1447523Hi, 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.
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
Your CP Date examples are outside of the range of the regular dates.
I'm sorry, this is better example:
https://drive.google.com/file/d/1gev9T2o3TtpKpcxUfqRMjqSSAkyB1sF4/view?usp=drive_link
Hello,
Any update on this.
this is solution, thank you
