Forum Discussion

Md_Ruman's avatar
Md_Ruman
Regular Visitor
3 years ago
Solved

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 sa...
Need Help
  • Dhairya's avatar
    Dhairya
    3 years ago

    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's avatar
Md_Ruman
Regular Visitor
3 years ago

Dhairyadanextian  : The solution provided is not working in this case.
Explaining the exact requirement here:

1. We have a table containing below columns:

categoryfield
HappayPartner
MSMPartner
PaherPartner
MagalingPartner
Chatra CityBranch
TandwaBranch
KodarmaBranch
Hazaribagh cityBranch
FarmingAsset
Micro serviceAsset
animal husbandryAsset


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:

Categoryloan app_idLoan amount
Happay367    25,000.00
MSM890    34,670.00
Paher1120    78,000.00
Magaling760    23,890.00
Total3137 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's avatar
danextian
Super User
3 years ago

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