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.

     

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

Step 1) Create a unified calculated table in DAX

CombinedTable =
UNION (
    SELECTCOLUMNS (
        TableA,
        "Date",   TableA[Date],
        "Value",  TableA[Value],
        "Series", "Actual"
    ),
    SELECTCOLUMNS (
        TableB,
        "Date",   TableB[Date],
        "Value",  TableB[Value],
        "Series", TableB[Forecast Version]
    )
)

 

Step 2) Create a single measure

Consumption =
SUM ( CombinedTable[Value] )

 

Step 3) Configure the line chart

  • X axis: Date
  • Y axis: Consumption
  • Legend: Series

 

Step 4) Connect CombinedTable to your Date table

Modeling tab → Manage Relationships → create a relationship between CombinedTable[Date] and your Date table