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.

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.