Table with Rows and Columns switched to support ToolTip

[dgwilson]

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

[Aron_Moore]

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.

[ChrisMendoza]

@dgwilson -

Not sure if this is something that may help https://www.sqlbi.com/articles/displaying-filter-context-in-power-bi-tooltips/

[dgwilson]

@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 · Accepted solution]

@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.

[v-lili6-msft]

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.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31560820-extend-dax-format-functi...

Best Regards,

Lin

[dgwilson]

@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]

hi, @dgwilson 

You're welcome. 

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