Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Custom Tooltip not showing correct values

Hi, I have a stacked column chart that shows the Cost of Production split between the specific inputs.  I wanted to create a custom tooltip that shows the cost for the specific in...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

I tried using a different measure,

 

 

_SeleInput2 = 
VAR CurrentInput =
    SWITCH(
        TRUE(),
        NOT(ISBLANK(MAX('CAD$,T,Ha'[Fertiliser]))), [_CurrencyFertiliser],
        NOT(ISBLANK(MAX('CAD$,T,Ha'[Pesticides]))), [_CurrencyPesticides],
        NOT(ISBLANK(MAX('CAD$,T,Ha'[Machinery]))), [_CurrencyMachinery],
        NOT(ISBLANK(MAX('CAD$,T,Ha'[Fuel and Energy]))), [_CurrencyFuelAndEnergy],
        NOT(ISBLANK(MAX('CAD$,T,Ha'[Seed]))), [_CurrencySeed],
        NOT(ISBLANK(MAX('CAD$,T,Ha'[Irrigation Water]))), [_CurrencyIrrigation],
        NOT(ISBLANK(MAX('CAD$,T,Ha'[Labour]))), [_CurrencyLabour],
        NOT(ISBLANK(MAX('CAD$,T,Ha'[Land Rent]))), [_Currency Land Rent],
        NOT(ISBLANK(MAX('CAD$,T,Ha'[Property and Utilities]))), [_CurrencyProperty and Utilities],
        NOT(ISBLANK(MAX('CAD$,T,Ha'[Administration]))), [_CurrencyAdministration],
        NOT(ISBLANK(MAX('CAD$,T,Ha'[Finance]))), [_CurrencyFinance],
        NOT(ISBLANK(MAX('CAD$,T,Ha'[Other]))), [_CurrencyOther],
        BLANK()
    )
RETURN
CurrentInput

 

 

 

It does return a value, however it return the same value for all the segaments when hovered over. The value it returns is always the first input after the TRUE () statement (in this case fertilizer). It appears that if it finds a value, it does not consider the rest of the lines, which must mean that it does not recognize the filtering properly. 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Thank you for your answer!! 

    It works!! 

    I have been struggeling with this issue for the last week, so thanks a lot! 

    If you have the time, could you explain why this works and the other solution does not?