Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Order tooltip values descending

Hi,

 

Can we order higher to lower values? 

hope to be 

 

3738

425

69

1

1

 

 

General Comment
Need Help
Show and Tell
  • danextian's avatar
    danextian
    1 year ago

    While you can use a page tooltip, creating a calculated table to materialize measures is not the right approach. Calculated tables are static and do not respond to slicers or cross-filtering, even if the measures they reference do. A better solution is to use a disconnected table that lists the measure names in a column, then reference that column in a measure to return the corresponding value based on the current row.

     

    The Hex colums above are the to be used to create a DAX-generated conditional formatting icons. SVG Conditional formatting icons do not accept hexadecimal values starting with # so %23 is used instead

     

    Circle Icon = 
VAR _Color =
    SELECTEDVALUE(MeasuresToBeSorted[Hex2])

VAR _SVG =
    "data:image/svg+xml;utf8," &
    "<svg xmlns='http://www.w3.org/2000/svg' width='20' height='20'>" &
        "<circle cx='10' cy='10' r='8' fill='" & _Color & "' />" &
    "</svg>"

RETURN _SVG

    Notice that the sorting of the measures in the imabe below changes.

    Please see the attached pbix.

6 Replies

  • danextian's avatar
    danextian
    Super User
    1 year ago

    Hi Anonymous 

    That isnt currently possible. Measure tooltips are ordered based on their order in the tile field. Tooltips from using  a legend follow the sort order of the legend values. 

  • grazitti_sapna's avatar
    grazitti_sapna
    Super User
    1 year ago

    Hi Anonymous,

     

    Power BI do not support sorting multiple measures dynamically in descending order.

    But you can achive this by below work around 

     

    TooltipTable =
    UNION(
    SELECTCOLUMNS(VALUES('YourTable'), "Measure", "Metric A", "Value", [MeasureA]),
    SELECTCOLUMNS(VALUES('YourTable'), "Measure", "Metric B", "Value", [MeasureB]),
    SELECTCOLUMNS(VALUES('YourTable'), "Measure", "Metric C", "Value", [MeasureC])
    )

     

    Then sort TooltipTable by Value descending.

    Add a tooltip page, create a table and add the values to it.

    Show it as a tooltip on your visual.

     

    🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
    💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
    🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
    🔗 Curious to explore more? [Discover here].
    Let’s keep building smarter solutions together!

    • danextian's avatar
      danextian
      Super User
      1 year ago

      You're sugesting OP to use a calculated table which won't be cross-filtered by by the dimensions in the line chart? That will return in accurate numbers for a specific data point.

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      I just created tooltip page before you advised, what is the impact creating below measure you suggested? 

       

      TooltipTable =
      UNION(
      SELECTCOLUMNS(VALUES('YourTable'), "Measure", "Metric A", "Value", [MeasureA]),
      SELECTCOLUMNS(VALUES('YourTable'), "Measure", "Metric B", "Value", [MeasureB]),
      SELECTCOLUMNS(VALUES('YourTable'), "Measure", "Metric C", "Value", [MeasureC])
      )

       

       

       

      • grazitti_sapna's avatar
        grazitti_sapna
        Super User
        1 year ago

        Hi Anonymous,

         

        You can skip it.

        Mark it as a solution if your issue has been fixed.