Dashed Line Representation for Future Dates

[mh20221111]

I'm creating a line graph using a measure with TOTALYTD, where the x-axis represents months and the legend represents years.The line for the most recent year is upward sloping until it reaches the last actual value, and then it becomes a straight line for future dates. I would like to make the portion representing future dates a dashed line.

I have a fact table containing date and value columns, which is related to a calendar table. I added a flag in the calendar table to distinguish between current and future dates. While I managed to display the current and future lines separately for the most recent year, the lines appear disconnected in the legend since they are treated as different series.

One approach I considered was to duplicate the data for the months that separate the current and future segments in the calendar table. This way, both flags would have data for those months, allowing the lines to connect. However, I'm concerned about creating a many-to-many relationship.

Is there a way to visually connect the current and future lines for the most recent year without establishing a many-to-many relationship, while still being able to display the line as a solid line for current dates and a dashed line for future dates?

[v-hashadapu]

Hi @mh20221111 , I hope you're doing well! Just checking in to see if you had a chance to review the details shared earlier. If any of the information addressed your needs, feel free to mark it as "Accept as Solution" or give it a 'Kudos' to help others in the community. Please let me know if you have any further questions!

[mh20221111]

Hi @v-hashadapu ,I would like to submit a feature request.

[v-hashadapu · Accepted solution]

Hi @mh20221111 , Thank you for contacting the Microsoft Community Forum.
To submit a feature request, please suggest it as an Idea in Fabric Ideas - Microsoft Fabric Community and encourage others to upvote it. Microsoft is more likely to implement features that receive the most support.
Thank you.

[mh20221111]

I posted it here.
Dashed Line Representation for Future Dates - Microsoft Fabric Community

[v-hashadapu]

Hi @mh20221111 ,
I hope the information shared was helpful. If you have any additional questions or would like to explore the topic further, feel free to reach out. If any of the responses resolved your issue, please mark it "Accept as solution" and give it a 'Kudos' to support other members in the community.
Thank you!

[v-hashadapu]

Hi @mh20221111 ,
I wanted to follow up and see if you’ve had a chance to review the information provided here. The answer provided by @danextian seems to be correct. please verify it and share your thoughts.
If it helped solve your issue, please consider marking it "Accept as Solution" and giving it a 'Kudos' to help others easily find it.
Let me know if you have any further questions!

[danextian]

Hi @mh20221111 

You will need to create two measures - one for the actual and another one for the future dates - and apply formatting to them separately. In order for them to connect, either one of them must have an overlap with the other. For example, if the future date start in June and the actual ends in May, the measure for the future date must include May as well otherwise you will see a gap in between.