Forum Discussion
create dynamic column or table responsing to filter /slicer
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
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:
- Click Query Editor -> Transform -> Unpivot columns [customer name] and [item name] to attribute-value in the second table.
- After applied, create a relationship between the two tables based on some columns.
- 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
2 Replies
v-yuta-msftCommunity Support
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:
- Click Query Editor -> Transform -> Unpivot columns [customer name] and [item name] to attribute-value in the second table.
- After applied, create a relationship between the two tables based on some columns.
- 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
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 ？