Forum Discussion

sudhakar111's avatar
sudhakar111
Helper IV
7 years ago
Solved

Display Percentages in tool tips

Hello,   I am facing an issue while displaying percentages in tool tips. We have one product and that product has sub products.   The percentage calculation should be how much percentage is each ...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi sudhakar111

    To display a tooptip in a text box,

    1.you could create a new report and add card visual on the report,

    2.then create a new measure like this

    Measure 2 = CALCULATE(SUM(Sheet3[BILLED_QTY]),ALLEXCEPT(Sheet3,Sheet3[sales office]))/CALCULATE(SUM(Sheet3[BILLED_QTY]),ALL(Sheet3))

    3.add this measure to the card visual,

    4.set this page as a tooltip by cilck on Format->Page information->turn on tooltip

    5. cilck on the bar chart with sales office, then click on Format->turn on tooltip->select the page your card visual display

    finally, when you mouse over the bar chart,you would see the card visual displaying as a tooltip.

     

    Reference:

    https://docs.microsoft.com/en-us/power-bi/desktop-tooltips

     

    Best Reagrds

    Maggie

     

     

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi sudhakar111

Based on my test, it could show spefic percentage for each office, could you share some screenshot to describe how you create the chart and tooltip page?

Besides, i'd like to suggest you open another thread for this additional problem and describe with more details so that we can help you better.

 

Best Regards

Maggie