Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 ?
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.