create dynamic column or table responsing to filter /slicer

[erche3]

Hello,

I am a newbie in Power BI

I am wondering if I could create a dynamic new column or table responsing the filter

for example ,   if I filter by "customer level " ,  then in this new column / table  will take {customer name} , 

or If I filter by "item level" , this new column will take {item name} .

so I could choose wanted group level in the comparison chart from the filter ,

or if there any better way to do it ？

thanks

Erik

[v-yuta-msft · Accepted solution]

Hi erche3,

Power BI doesn’t support dynamic calculate column, in addition, if my understanding is right, you have 2 tables, the first table has a column [level] which contains two different values “customer level” and “item level”, the second table has two columns [customer name] and [item name], right?

To achieve your requirement, you can take steps below as a reference:

1. Click Query Editor -> Transform -> Unpivot columns [customer name] and [item name] to attribute-value in the second table.
2. After applied, create a relationship between the two tables based on some columns.
3. In Query Editor, merge the two table into a new table.

Now you can create a slicer on [level] to filter values.

Regards,

Jimmy Tao

[erche3]

Great!

this is a smart way to do it . thanks very much !

then I suppose first I need to dulipcate the second data table , and do this unpivot separately on another table,  in order to build this deviation chart , with custom filtering "customer level" or " item level"

because I have   another sales overview on monthly level ,  if I take from the same  table ("unpivoted [customer name] and [item name] ) ,  I will get a double volume on monthly .

right ？