Forum Discussion

Hennry2344's avatar
Hennry2344
Regular Visitor
6 years ago
Solved

highlight and tooltip

When I cross-filter my sales bar chart by country, I want to display the highlight of my bar chart by manufacturer but in percentage, normally Power Bi displays it in absolute values. ...
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    Hi , Hennry2344 

    I didn't find any error in your formula.

    I guess that  hightlight will not affect the  measure filed in tooltip.

     

    As a workaroud,you can try to create a custom tooltip by using "text box" and the  "Card" visual.
    And you need to modify the page backgroud color,tooltip page size,visual font size....

    The result will show as below:

    Please check the attached pbix file for more details.
    pbix attached

     

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

  • Hennry2344's avatar
    Hennry2344
    Regular Visitor
    6 years ago
    % Selected =
    VAR TotalRevenue = CALCULATE(SUM(Sales[Revenue]),ALL(Sales), VALUES(Manufacturer[Manufacturer]))
    VAR highlighted = CALCULATE(SUM(Sales[Revenue]), ALLSELECTED(Sales[Country]))
    return
    DIVIDE(highlighted,TotalRevenue )
    • v-easonf-msft's avatar
      v-easonf-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi , Hennry2344 

      I didn't find any error in your formula.

      I guess that  hightlight will not affect the  measure filed in tooltip.

       

      As a workaroud,you can try to create a custom tooltip by using "text box" and the  "Card" visual.
      And you need to modify the page backgroud color,tooltip page size,visual font size....

      The result will show as below:

      Please check the attached pbix file for more details.
      pbix attached

       

      Best Regards,
      Community Support Team _ Eason
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.