topic Re: Dax Measure showing selected column in table/ matrix in DAX Commands and Tips

Dax Measure showing selected column in table/ matrix

Kopek — Mon, 03 Jun 2024 13:34:16 GMT

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:

Re: Dax Measure showing selected column in table/ matrix

lbendlin — Mon, 03 Jun 2024 22:32:12 GMT

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

Re: Dax Measure showing selected column in table/ matrix

Anonymous — Tue, 04 Jun 2024 02:52:45 GMT

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

Re: Dax Measure showing selected column in table/ matrix

Kopek — Wed, 05 Jun 2024 14:26:01 GMT

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

thanks for your help! 🙂