Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
hi all,
i have a complex matrix in a following form:
The measures are dynamic in dependence of a quarter filter and are like:
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.
Ok thanks for feedback. What would be the best workaround?
@Pikachu-Power , Think display name in title , as shown in this blog - https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...
Currently, according to my knowledge, you can't dynamically change the names of columns in a the standard matrix visual.
@Pikachu-Power , You can change the title based similar kind of formula. But I doubt you can change the measure name.
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |