Dinamically change table dimension

[MaxItaly]

Hello everyone,

what I'd like to achieve is something like this: How to change measure value using parameters.

But, what I'd like to achieve is something different.

Let's say I have a table with the following columns:
Customer (dimension); This year sales (Measure); This year quantity (measure).

What I'd like to achieve is to change dinamically not the a measure, but the dimension (Customer), for example, with "Region".

Is it possible? Or do I have to use the old bookmark trick? I don't really like it since it cause some minor problems....

[v-shex-msft · Accepted solution]

Hi @MaxItaly,

AFAIK, current power bi not support to create dynamic calculated column/table based on filter and slicer.

Calculated Column/Table Change Dynamically According to Slicer Selection in the Report.

If you mean dynamic calculated column, it is impossible to achieve this at present.

Regards,

Xiaoxin Sheng

[MaxItaly]

Many thanks, I really appreciated the article. Very clear.