Microsoft Power BI - columns for different periods

[doldg]

How can I have different columns showing for different periods?

Example; I want a report to show actuals for 2021 and 2022, but then I want the next columns to just show future budgets.

When I try to do a report it shows me actuals and budgets for all of the years.

Thanks

[Icey · Accepted solution]

Hi @doldg ,

Here is a detailed example. Hope it could help you.

Article: Showing actuals and forecasts in the same chart with Power BI - SQLBI

Video: Showing actuals and forecasts in the same chart with Power BI - SQLBI

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Nathaniel_C]

Hi @doldg ,
Will attempt this with the limited info you have given us.  You don't say how the data is arranged in your table. However you might create a measure use something like If (Actuals <> 0, then Actuals) in one column.  In the next column If (Actuals = 0, then Budgets)  

Let me know whether you wish to do this in Power Query (best) or in DAX as a measure.

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel