Need to create a static chart with dynamic numbers

Hi anshenterprice ,

Are you using the following visualization?

If so, based on the sample and description you provided, please try the following steps:

1.Use the following code to create Measure.

Equity_Value = CALCULATE(SUM('Table'[Value]),
                         FILTER('Table','Table'[Script] = "Equity" && 'Table'[Date] = MAX('Table'[Date]))
                        )

Commodity_Value = CALCULATE(SUM('Table'[Value]),
                            FILTER('Table','Table'[Script] = "Commodity" && 'Table'[Date] = MAX('Table'[Date]))
                           )

currency_Value = CALCULATE(SUM('Table'[Value]),
                           FILTER('Table','Table'[Script] = "currency" && 'Table'[Date] = MAX('Table'[Date]))
                          )

2.Put the measure value into your Visualization and do the following.

3.Set the maximum value to 5 in the Visualization panel.

When you select "1/29/2024" in the slicer, Result is as below.

Best Regards,
Yulia Yan

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