Forum Discussion
Kopek
Helper IV
2 years agoDax 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 Name Date Region Plan Name 1 DD/MM/YYYY UK Plan Name 2 D...
- Anonymous2 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 tableTable 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 _b3.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
lbendlin
Super User
2 years agocustom 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