Forum Discussion

Kopek's avatar
Kopek
Icon for Helper IV rankHelper IV
2 years ago
Solved

Dax Measure showing selected column in table/ matrix

Hello!

 

I am trying to create a measure for customize tooltip.

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

 

Plan NameDateRegion
Plan Name 1DD/MM/YYYYUK
Plan Name 2DD/MM/YYYYUSA

 

 

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's avatar
    Anonymous
    2 years ago

    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

     

     

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      Kopek
      Icon for Helper IV rankHelper IV
      2 years ago

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

      thanks for your help! 🙂