How to hover on table visual in PowerBI

[Md_Ruman]

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.

[Md_Ruman]

@Dhairya@danextian  : 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.

[Dhairya]

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! 

[Md_Ruman]

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.

[Md_Ruman]

Hi @Dhairya : It's working for me, Thanks for your support.

[Dhairya · Accepted solution]

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!

[Md_Ruman]

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. 

[danextian]

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]

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 visual

If 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.

[danextian]

Please provide a sample data and your expected result. Here's a guide on how you can get a better resonse:

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/3194...