cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Post Prodigy

## dynamic column name in complex matrix

hi all,

i have a complex matrix in a following form:

The measures are dynamic in dependence of a quarter filter and are like:

Measure1 =
VAR _SelectedMeasure = SELECTEDVALUE ( Table[Quarter] )
RETURN
SWITCH(
_SelectedMeasure,
"Q1",[Plan],
"Q2",[FCI],
"Q3",[FCII],
"Q4",[FCIII]
)

All measures are different. For example measures for previous year or cumulative values.

So it is possible to give the measures a dynamic name? For measure1 for example i want Plan 2021, FC I 2021, FC II 2021, FC III 2021 in dependence of the filters Year and Quarter.

Thanks!

5 REPLIES 5
Community Support

It is not supported to create dynamic meausre name.

You can try to create a new table with all measure names needed via "Enter Data". For example:

 Sort MeasureName 1 Plan 2021 2 FC I 2021 3 FC II 2021 4 FC III 2021 5 Plan 2020 6 FC I 2020 7 FC II 2020 8 FC III 2020 ... ...

Then, create a measure to replace "Measure1" in your table visual like so:

``````Measure 1 - 1 =
VAR SelectedYear =
SELECTEDVALUE ( 'Table'[Year] )
VAR SelectedQuarter =
SELECTEDVALUE ( 'Table'[Quarter] )
VAR SelectedMeasureName =
SELECTEDVALUE ( 'MeasureNameTable'[MeasureName] )
RETURN
SWITCH (
SelectedYear,
2021,
IF (
( SelectedQuarter = "Q1" && SelectedMeasureName = "Plan 2021" )
|| ( SelectedQuarter = "Q2" && SelectedMeasureName = "FCI 2021" )
|| ( SelectedQuarter = "Q3" && SelectedMeasureName = "FCII 2021" )
|| ( SelectedQuarter = "Q4" && SelectedMeasureName = "FCIII 2021" ),
[Measure1]
),
2020,
IF (
( SelectedQuarter = "Q1" && SelectedMeasureName = "Plan 2020" )
|| ( SelectedQuarter = "Q2" && SelectedMeasureName = "FCI 2020" )
|| ( SelectedQuarter = "Q3" && SelectedMeasureName = "FCII 2020" )
|| ( SelectedQuarter = "Q4" && SelectedMeasureName = "FCIII 2020" ),
[Measure1]
)
)
``````

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Post Prodigy

Ok thanks for feedback. What would be the best workaround?

Super User
Anonymous
Not applicable

Currently, according to my knowledge, you can't dynamically change the names of columns in a the standard matrix visual.

Super User

@Pikachu-Power , You can change the title based similar kind of formula. But I doubt you can change the measure name.