Custom Tooltip not showing correct values

Hi Anonymous ,

Here I suggest you to create a Legend table with all type you need in chart Legend.

Legend =
DATATABLE (
    "Legend", STRING,
    "Order", INTEGER,
    {
        { "Seed", 1 },
        { "Fertiliser", 2 },
        { "Pesticides", 3 },
        { "Machinery", 4 },
        { "Fuel and Energy", 5 },
        { "Irrigation Water", 6 },
        { "Labour", 7 },
        { "Land Rent", 8 },
        { "Property and Utilities", 9 },
        { "Administration", 10 },
        { "Finance", 11 },
        { "Other", 12 }
    }
)

Then create a measure as below.

MEASURE =
SWITCH (
    SELECTEDVALUE ( Legend[Legend] ),
    "Seed", [_CurrencySeed],
    "Fertiliser", [_CurrencyFertiliser],
    "Pesticides", [_CurrencyPesticides],
    "Machinery", [_CurrencyMachinery],
    "Fuel and Energy", [_CurrencyFuelAndEnergy],
    "Irrigation Water", [_CurrencyIrrigation],
    "Labour", [_CurrencyLabour],
    "Land Rent", [_Currency Land Rent],
    "Property and Utilities", [_CurrencyProperty and Utilities],
    "Administration", [_CurrencyAdministration],
    "Finance", [_CurrencyFinance],
    "Other", [_CurrencyOther],
    BLANK ()
)

Result is as below.

Best Regards,
Rico Zhou

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