Forum Discussion

dgwilson's avatar
dgwilson
Icon for Resolver III rankResolver III
7 years ago
Solved

Table with Rows and Columns switched to support ToolTip

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...
Need Help
  • dgwilson's avatar
    dgwilson
    7 years ago

    ChrisMendoza -

     

    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
     
    I'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.
     
dgwilson's avatar
dgwilson
Icon for Resolver III rankResolver III
7 years ago

v-lili6-msft 

 

Voted. Thank you.

Thank you for confirming I can not format colour. YOu've save me many hours of internet searching.

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

hi, dgwilson 

You're welcome. :smileyvery-happy:

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