Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Pikachu-Power
Post Prodigy
Post Prodigy

dynamic column name in complex matrix

hi all,

 

i have a complex matrix in a following form:

 

Unbenannt.PNG

 

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
Icey
Community Support
Community Support

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.

Pikachu-Power
Post Prodigy
Post Prodigy

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

Anonymous
Not applicable

@Pikachu-Power 

 

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

amitchandak
Super User
Super User

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.