Forum Discussion
How to hover on table visual in PowerBI
Hey Md_Ruman
Please follow the below steps to achieve your requirements
Step 1: Create the following measures
Total Loan app_id = SUM(Data[ loan app_id])
Total Loan amount = SUM(Data[ Loan amount])
Loan app_id % Contribution =
DIVIDE(
[Total Loan app_id],
CALCULATE([Total Loan app_id],ALLEXCEPT(Data,Data[field]))
)
Loan Amount % Contribution =
DIVIDE(
[Total Loan amount],
CALCULATE([Total Loan amount],ALLEXCEPT(Data,Data[field]))
)
Step 2: Add a new page to your report and name it Custom Tooltip and change the type of canvas to "Tooltip", and plot above created two measures ("Loan app_id % Contribution" and "Loan Amount % Contribution") which you want to display while hovering on visual.
Step 3: Plot your slicer and required visual i.e., table or matrix, here I have used table visual, now go to tooltip settings under the format visual pane and select type as "Report Page" and Page as "CustomTooltip"(newly created tooltip page).
Step 4: Now on hovering over any records of your visual you will get the expected result as shown below
If this helps you then please mark my solution as accepted so that other user can find it quickly when they encounter similar issue!
Thank You!
Hi Dhairya : The solution is working for me, but have one doubt, Please clarify how did you add multiple column values in card visual in custom tooltip that you have created.
or did you import some other visual? i wanted to know how did you show multiple values in the card custom tooltip.
Hey Md_Ruman
to display multiple values in the tooltip, I have just added two different cards with different measures.
you can add multiple visuals on your custom tooltip, depending on your use case.
Please mark my solution as accepted if you got a clear idea. Thank you!Hi Dhairya danextian : I need one help to show my alerts or to highlights default in my powerbi report visuals.
I am explaining complete process here:I have used line and stacked column chart visual on which i present state on x-axis, loan amount on y-axis and collection in that state in secondary y-axis, but i wanted to add one more field which will highlight or show us the default, like which state is going to default more, so we need to add some highlight or alerts. Please let me know, if it is clear, please suggest how to do this.