Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi there...
Seeking some suggestions and advice on presentation of a tooltip.
I have, what I consider to be, a large dataset with millions of rows of corporate financial data. I have a screen that provides "drill down" on the transaction detail... it does quickly (6 x drill downs) get to the point where drill down is tedious and it's a good time to show a tool tip.
Like us all, I want the tool tip that is presented to look slick and well crafted. And I want it to be easily maintained if necessary.
I have about 30 or more fields that I want to show in the tooltip... and thought that a simple table with field name on the left and row details on the right would be simple and meet my needs exactly. However if the table can flipped 90 degrees - I can't see how that's done.
What does everyone else do for this? What do you recommend?
- David
Solved! Go to Solution.
For now... I've decided this will work...
_DumpValues = VAR CRLF = UNICHAR(13) & UNICHAR(10) VAR theText = "AMOUNT GC = " & FORMAT(FIRSTNONBLANK(EVO_DMT_BUS_CUST_PROFIT_VW[AMOUNT_GC], 1), "Currency") & CRLF & "DATA_SOURCE = " & FIRSTNONBLANK(EVO_DMT_BUS_CUST_PROFIT_VW[DATA_SOURCE], 1) & CRLF & "DATA_TYPE_DETAIL = " & FIRSTNONBLANK(EVO_DMT_BUS_CUST_PROFIT_VW[DATA_TYPE_DETAIL], 1) & CRLF & "DATA_TYPE_SUMMARY = " & FIRSTNONBLANK(EVO_DMT_BUS_CUST_PROFIT_VW[DATA_TYPE_SUMMARY], 1) & CRLF RETURN theText
What I did was create a "table" which is just an image of table (borders of the cells/layout), then used card visualizations as the "cells". It takes a second or so to load with the tooltip, but gave us that flexibility.
Not sure if this is something that may help https://www.sqlbi.com/articles/displaying-filter-context-in-power-bi-tooltips/
Proud to be a Super User!
Filter contexts are not what I'm after... however... the idea of doing this in DAX code rather than a predone visual as such is a good idea and would work well for me... and it's maintainable. I"ll give that a go. Thanks.
For now... I've decided this will work...
_DumpValues = VAR CRLF = UNICHAR(13) & UNICHAR(10) VAR theText = "AMOUNT GC = " & FORMAT(FIRSTNONBLANK(EVO_DMT_BUS_CUST_PROFIT_VW[AMOUNT_GC], 1), "Currency") & CRLF & "DATA_SOURCE = " & FIRSTNONBLANK(EVO_DMT_BUS_CUST_PROFIT_VW[DATA_SOURCE], 1) & CRLF & "DATA_TYPE_DETAIL = " & FIRSTNONBLANK(EVO_DMT_BUS_CUST_PROFIT_VW[DATA_TYPE_DETAIL], 1) & CRLF & "DATA_TYPE_SUMMARY = " & FIRSTNONBLANK(EVO_DMT_BUS_CUST_PROFIT_VW[DATA_TYPE_SUMMARY], 1) & CRLF RETURN theText
hi, @dgwilson
For a way to alternately colour the text in DAX, You could format the color of the whole tooltip but not alternately.
Currently, it is not possible to change text formatting using DAX. There is a similar thread about this issue, please vote it up.
Best Regards,
Lin
Voted. Thank you.
Thank you for confirming I can not format colour. YOu've save me many hours of internet searching.
hi, @dgwilson
You're welcome.
Could you please tell me if you still have other problem? If not, could you please mark the helpful replies as Answered?
Best Regards,
Lin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |