Forum Discussion
Add new column
Dear Pragati11,
I have 7k unique values in Column1.
I don't want to replace anything in my new column, just add a filter from other column and get a new column with filtered values.
Copy all values from Column1 into my new column with added filter (or condition, I don't know) where Event name = "result clicked" and thats how get a whole new column with filtered values which are only result clicked.
Hi gduobaite ,
Is the requirement on getting this new column is in your source data?
If not then just drag COLUMN1 to a table visual --> Create a slicer on COLUMN1 --> select values in slicer -- Table visual will get updated based on slicer selection.
If this is not the case then please add more detail with th example as your 1st example is not clear enough to answer your query.
Thanks,
Pragati
Pragati11 , I need a new column with filter in the formula inside, that in the future I could add several columns like that but with different filters into my table visual. Otherwhise, If I'm using one filter (slicer) to whole table visual, it affects all columns. But I don't need that.
It sounds strange that you should need to add (more) filtered columns to a table (in the future?).
Perhaps if you show a mock up of what you need to do and why (the model, fact/dimension tables and final visual) we can help with a more practical solution.
A sample dataset or PBIX file would be great.
If this is your requirement, as Pragati11 said, only solution is to add new columns to your table like:
Column2 = IF('Table1'[Column1] = "A", 'Item'[Column1], " ")
Column3 = IF('Table1'[Column1] = "B", 'Item'[Column1], " ")
hi gduobaite
I'm a little confused by your description, could you please share your sample pbix file and your expected output, that will be a great help.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490Regards,
Lin
