Forum Discussion

dgwilson's avatar
dgwilson
Resolver 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 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

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.
     

7 Replies

    • dgwilson's avatar
      dgwilson
      Resolver 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
        Resolver 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.
         
  • Aron_Moore's avatar
    Aron_Moore
    Solution Specialist
    7 years ago

    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.