Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
Solved! Go to 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:
Now you can create a slicer on [level] to filter values.
Regards,
Jimmy Tao
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:
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 ?
User | Count |
---|---|
84 | |
81 | |
64 | |
53 | |
45 |
User | Count |
---|---|
100 | |
48 | |
42 | |
39 | |
38 |