Forum Discussion

dgwilson's avatar
dgwilson
Icon for Responsive Resident rankResponsive Resident
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.
     
Aron_Moore's avatar
Aron_Moore
Icon for Solution Specialist rankSolution 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.