Forum Discussion
Tooltip view different after adding legend
I have a chart where i am able to see the following tooltip (GP1 and its sum on that date,GP2 and its sum on that date, when i hover on a particular date).
But when i add a legend field in this chart the tooltip doesn't show me the desired view ( I am supposed to see GP,GP1,GP2,GP3... But i am only seeing GP when i hover on GP line and GP1 when i hover on GP1. while i want to hover on x axis and see all the values of (aggregated Y axis) i.e GP on that particular date)
Tried removing the Tooltip but when i hover on the date axis instead of seeing all the GP values i can only see the GP that i point to :
When I use date field instead of datetime in this particular chart then i am able to see the tooltip with different GP values. I am not sure where am I doing wrong.
amitchandak parry2k Fowmy @@please guide me throu
PS: Can't share the pbix due to its large size
4 Replies
Anonymous on the tooltip page, turn off, Keep All filters and add the column date that you used on x-axis under the drill thru section (in following screenshot I have shipment column, you will have date there) and that will do it,
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
parry2k it didn't worked. However if i change my datetime field with only date field i able to see the tooltip with different GP. but i need the datetime value as i need the time interval as well. I checked the format of datetime it's correct as it is working in the first chart however when i add the legend field it fails to show me the y axis value when i hover on a date field.
Anonymous whatever DateTime field you are using x-axis that will in drill thru section of the tooltip page. It should work.
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
sorry parry2k i am not able to resolve it but i found what's the issue and i am not able to resolve it
