Forum Discussion

Ignite190's avatar
Ignite190
Frequent Visitor
6 months ago
Solved

Requirement: Line chart with Actual + multiple Forecast Versions (dynamic) from different tables

Hi everyone, I’m looking for guidance on a Power BI limitation / workaround for a line chart scenario. Business requirement I need to visualize: Actual consumption data Multiple forecast versio...
Need Help
  • danextian's avatar
    danextian
    6 months ago

    Hi Ignite190 

    Line charts in Power BI allow either multiple measures (series) as a legend or categories from a column. That said, is to use a disconnected with a column the actual measure name and the forecast version and reference this column in  a measure. Then use the original version column as a slicer.

    Please see the attached pbix.

     

grazitti_sapna's avatar
grazitti_sapna
Icon for Super User rankSuper User
6 months ago

Hi Ignite190,

 

CAn be achived by appending both tables together and then using them in Line chart.

 

I've created a sample .pbix file for you. Hope this is what you require.

 

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!