Forum Discussion
How to hover on table visual in PowerBI
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.
- danextian
Super User
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
- Dhairya
Solution Supplier
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!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.
