Forum Discussion
Messure - Tooltips
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
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1 Reply
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
