Forum Discussion

Ignite190's avatar
Ignite190
Frequent Visitor
5 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
    5 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.

     

Kedar_Pande's avatar
Kedar_Pande
Icon for Super User rankSuper User
5 months ago

Ignite190 

Create Table:

Combined Data = 
UNION(
SELECTCOLUMNS(TableA, "Date", TableA[Date], "Version", "Actual", "Value", TableA[Consumption]),
ADDCOLUMNS(
TableB,
"Version", TableB[Forecast Version],
"Date", TableB[Date],
"Value", TableB[ForecastConsumption]
)
)

Combined[Date] → DateTable[Date]

 

Measure:

Consumption Value = 
SUM(Combined Data[Value])

Line Chart:

X-axis: Date

Y-axis: Consumption Value

Legend: Version (Actual + all dynamic forecasts)