Forum Discussion
create dynamic column or table responsing to filter /slicer
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
Community SupportHi 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 ？