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

ChrisMendoza -

 

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