Forum Discussion
Order tooltip values descending
- 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 _SVGNotice that the sorting of the measures in the imabe below changes.
Please see the attached pbix.
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.