Sales Actuals and Targets

we use line charts in such scenarios. Is that an option for you?

Hi Wepenarian,

Thank you for reaching out to Microsoft Fabric Community Forum.
lbendlin Thank you for your quick response.

In this scenario, you can create a Line chart.
Line charts usually need a category axis (like time or labels), but you can create this using a disconnected table.

Create a disconnected calculated table with labels as,

Mtable = DATATABLE(
"Metric", STRING,
{
{"Actuals"},
{"Best Forecast"},
{"Forecast"},
{"Worst Forecast"}
}
)

then, Create a measure to display values dynamically:

SELECTION =
SWITCH(
     SELECTEDVALUE(MTable[Metric]),
         "Sales Actuals", SUM(chart[Sales Actuals]),
         "Best Forecast", SUM(chart[Best Forecast]),
         "Forecast", SUM(chart[Forecast]),
         "Worst Forecast", SUM(chart[Worst Forecast])
)

Pick a Line Chart:

     in Axis: MTable[Metric]

     in Values: SELECTION

Then, This shows all four values on a single axis, connected by a line . You can even create a clustered column chart as well in the same way.

Attached is the sample PBIX file for your reference.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Regards,
B Manikanteswara Reddy