Messure - Tooltips

MIKR0606 · ‎09-19-2023

Hi

I am new to DAX and POWERBI.

I would like to make a messure fore the tooltips, when i hoover over ex. Juni, which shows an incline in custom duty, which has to be paid. When you hoover over Juni, should show if possible, the 3 or 5 higest values from Customs duty table and item name.

Customs duty, is calculated ((Amount*Duty1%)+(Amount*Duty2)+((Quantity*Net weight)*Duty)))

Ex attached, amout is fictive

Hope some body have the time to help og guide me in the right way,

Item numberProduct nameDuty1 %Duty2 %DutyQuantityAmountGross WeightNet WeightCalculated duty2

1006340-T1	HONEY 450 GR 15.87 OZ	17,30%	0,00%	0,00	0	0	0,00
1048348-T1	TUNA SHREDDED IN SOYA OIL 170 GR CANNED	24,00%	0,00%	0,00	0,00	665,00	159,60
1121734-T1	BEEF CUBE ROLL/RIB EYE WHOLE EX-CHILLED FROZEN	12,80%	0,00%	22,62	0,00	784,00	100,35
1459060-T1	CHICKEN WHOLE WITHOUT GIBLETS (GRILLER) 1.2 - 1.6 KG FROZEN	0,00%	0,00%	2,22	0,00	839,00	0,00
1047657-T1	CHICKEN WHOLE WITHOUT GIBLETS (GRILLER) 1.1 KG FROZEN	0,00%	0,00%	2,42	0,00	641,00	0,00
1010556-T1	TILAPIA WHOLE 300 - 500 GR FROZEN	8,00%	0,00%	0,00	0,00	269,00	21,52
1010466-T1	SNAPPER RED WHOLE FROZEN	15,00%	0,00%	0,00	0,00	267,00	40,05
1464583-T1	BEANS MUNG YELLOW SPLIT DRIED (MOONG DAL) 1 KG 2.2 LB	0,00%	0,00%	0,00	0,00	929,00	0,00
1109764-T1	CUMIN POWDER 1 KG	0,00%	0,00%	0,00	0,00	760,00	0,00
1047955-T1	LAMB MEAT PIECES W/ BONE SALT CURED NORWEGIAN TYPE FROZEN	12,80%	0,00%	0,00	0,00	654,00	83,71

christinepayton · ‎09-19-2023

Yes, you can use custom tooltips for this. Add another hidden report tab that is smaller in size and designated as a tooltip page. Then add a table to the page. You can add your fields to the table, sort it by the thing you're measuring, and optionally limit it to 3 rows with a Top N visual-level filter. Make sure your original chart is set to use the custom tooltip in visual settings. https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips?tabs=powerbi-desktop