Forum Discussion

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

     

MFelix's avatar
MFelix
Icon for Super User rankSuper User
4 months ago

Hi Ignite190 ,

 

Create a new table with a line saying actuals and the versions fo your forecasts v1, v2 and só on. For this to BE dynamoc you can use Power query or dax.

 

Then add a new measure similar to this One

 

Atual + forecasts = 

IF(SELECTEDVALUE(Newtable[columname]), [Actual], CALCULATE([Forecast]), Forecastable[Forecast] = SELECTEDVALUE (Newtable[Columname])))

 

Then you can use this measure on the values and the column from the new table has Legend.