Forum Discussion
Resolver IIITable with Rows and Columns switched to support ToolTip
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 theTextI've been searching for a way to alternately colour the text in DAX... and thus far am unsuccessful.Otherwise... after codeing for the 3+ fields... it's all done and is maintainable.
Resident Rockstardgwilson -
Not sure if this is something that may help https://www.sqlbi.com/articles/displaying-filter-context-in-power-bi-tooltips/
Resolver III
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.
- dgwilson
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 theTextI've been searching for a way to alternately colour the text in DAX... and thus far am unsuccessful.Otherwise... after codeing for the 3+ fields... it's all done and is maintainable.
v-lili6-msftCommunity Support
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
- dgwilson
Voted. Thank you.
Thank you for confirming I can not format colour. YOu've save me many hours of internet searching.