Need to create a static chart with dynamic numbers

[anshenterprice]

Hi Team,

recently we have used Linear Guage chart in our dashboard

Script	Value	Date
Equity	4	1/30/2024
Commodity	3	1/30/2024
currency	5	1/30/2024
Equity	3	1/29/2024
Commodity	1	1/29/2024
currency	4	1/29/2024

we need to create a three bands based on the date filter and the above values from 1to 5 always
basically we need to create 5 colured texboxes like below 

Thanks

[v-weiyan1-msft · Accepted solution]

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.

[Ritaf1983]

Hi @anshenterprice 
It seems a classic scenario for a bullet chart.

Please refer :

https://www.youtube.com/watch?v=QcHeq5nJUTc

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