Forum Discussion
How to hover on table visual in PowerBI
I have different categories and have some measures to get the sales amount while changing the categories, but i wanted to see the % of sales amount while hover on to that particular cell which has sales amount distributed over category. I tried doing this using Tooltip but it's not working for me, please suggest some of the ways to so this in powerbi Desktop.
9 Replies
Please provide a sample data and your expected result. Here's a guide on how you can get a better resonse:
Hey Md_Ruman
Create a custom tooltip and plot whichever measures you want to show while hovering on any visual.
Use that newly created custom tooltip as your tooltip for that particular visualIf it helps you then please mark my solution as accepted !
and if you are still facing any problem then please provide more detail like sample input and expected output.Dhairyadanextian : The solution provided is not working in this case.
Explaining the exact requirement here:1. We have a table containing below columns:
category field Happay Partner MSM Partner Paher Partner Magaling Partner Chatra City Branch Tandwa Branch Kodarma Branch Hazaribagh city Branch Farming Asset Micro service Asset animal husbandry Asset
I have used this table to apply a slicer on the visuals and keep field column there in slicer. So, we got 3 different fields in slicer drop down (partner,branch and asset).
I have applied this slicer to my visual which is nothing but a matrix table that is showing category wise loan app_id and loan amount.
sample matrix visual look like:Category loan app_id Loan amount Happay 367 25,000.00 MSM 890 34,670.00 Paher 1120 78,000.00 Magaling 760 23,890.00 Total 3137 1,61,560.00 Please note for this i have selected slicer as partner, if we will change the slicer like branch or asset then it's corresponding value will show in the matrix visual.
Now, I wanted to see % percent contribution of each category when i hover on to the cell like loan app_id or amount i,e as i hover on suppose (367) it will show 11.69 % of the total and so on.
Please suggest some easy and correct way to do this.Hi Md_Ruman ,
This is why I asked for a sample data.
You need to get the subtotal for each field first and the sum of each category is to be divided by the subtotal of its corresponding field. Try this:
App id % = DIVIDE ( SUM ( Data[loan app_id] ), CALCULATE ( SUM ( Data[loan app_id] ), ALLEXCEPT ( Data, Data[Field] ) ) //subtotal by field )You can then use this measure in a visual that allows a measure as a custom tooltip
Hey Md_Ruman
Please follow the below steps to achieve your requirements
Step 1: Create the following measuresTotal 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!
