Forum Discussion

Pikachu-Power's avatar
Pikachu-Power
Impactful Individual
5 years ago

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!
 
Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Pikachu-Power 

     

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

  • Icey's avatar
    Icey
    Community Support
    5 years ago

    Hi Pikachu-Power ,

     

    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.