Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
5 years ago
Solved

Budgets vs Fact

Is it possible to do Matrix like this, with two lvl headers, 1st lvl must be dinamic depending on selected year and month     M1 = CALCULATE(SUMX(Table1, Value), Table1[Year] = Selected Y...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    HI Analitika,

    It is impossible to default matrix to customize headers as you wanted, measure expressions can be dynamically change based on the current selections.

    I'd like to suggest you create a matrix with the group and all measure expressions, then you can create some measures to show the selected ranges and use them on card visual to and combine with the matrix as custom headers.

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
5 years ago

HI Analitika,

It is impossible to default matrix to customize headers as you wanted, measure expressions can be dynamically change based on the current selections.

I'd like to suggest you create a matrix with the group and all measure expressions, then you can create some measures to show the selected ranges and use them on card visual to and combine with the matrix as custom headers.

Xiaoxin Sheng