Dax Measure showing selected column in table/ matrix

[Kopek]

Hello!

I am trying to create a measure for customize tooltip.

I am having a table with data with some simple data:

Plan Name	Date	Region
Plan Name 1	DD/MM/YYYY	UK
Plan Name 2	DD/MM/YYYY	USA

I am using above data in different matrix/ tables.
What i want to figure out is whether is it possible to create a dax calculation, which can indicate which column i hover over on currently, so that it can be used in a tooltip, to show column definition instead of tooltip data.
So, when hover-over on a Plan Name, I want to see "Plan Name Definition", For Date column "Date Definition", For Region column "Region Definition".
That might be when hover over on a column header or column content itself - no matter.
just want to have a different tooltip for each column in a table.
Tried to work with Selected value, and some other funcions, but without any success 😞
Any ideas are welcome!
Below some mockup of desired outcome:

[Anonymous · Accepted solution]

Hi @lbendlin ,thanks for the quick reply, I'll add further.

Hi @Kopek ,

You can use the 'Matrix' visual.'Table' visual doesn't meet your needs.The Table data is shown below:

Please follow these steps:
1. Use the following DAX expression to create a table

Table 2 = {"Plan Name","Date","Region"}

2.Use the following DAX expression to create a measure

Measure = 
VAR _a = SELECTEDVALUE('Table 2'[Value])
VAR _b = SWITCH(TRUE(),
_a = "Date",CONCATENATEX(SELECTCOLUMNS('Table',"Date",[Date]),[Date],UNICHAR(10)),
_a = "Plan Name",CONCATENATEX(SELECTCOLUMNS('Table',"Plan Name",[Plan Name]),[Plan Name],UNICHAR(10)),
_a = "Region",CONCATENATEX(SELECTCOLUMNS('Table',"Region",[Region]),[Region],UNICHAR(10))
)
RETURN _b

3.Use the following DAX expression to create a measure for tooltip

Measure 2 = 
VAR _a = SELECTEDVALUE('Table 2'[Value])
RETURN SWITCH(TRUE(),
_a = "Plan Name","Plan Name Definition",
_a = "Date","Date Definition",
_a = "Region","Region Definition")

4.Final output

[Kopek]

Hi @Anonymous , i have modified it a bit, but with matrix it works perfectly fine!

thanks for your help! 🙂

[lbendlin]

custom tooltips only work on cell level

column headers get the default tooltip

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41