Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have created blank column in Power Query by using the following step.
#"Added Custom" = Table.AddColumn(#"Sorted Rows", " ", each "")
However, I don't want this column to appear in the final results. Is there a way to hide the column when the data is closed and loaded?
Transpose option doesn't help to hide the column. Thank you!
Solved! Go to Solution.
Hi @vineshparekh, if you do not need this column in final result, just delete it.
hi @vineshparekh ,
to hide a column once loaded into the model:
1. select the elipsis:
2. hide
regardless, i agree with @dufoq3 , if you don't need the column, might as well remove it in power query before loading.
hi @vineshparekh ,
to hide a column once loaded into the model:
1. select the elipsis:
2. hide
regardless, i agree with @dufoq3 , if you don't need the column, might as well remove it in power query before loading.
Hi @vineshparekh, if you do not need this column in final result, just delete it.
Hi @dufoq3
I have PDFs coming each month and this query adds a column for the current month invoices.
For example,
Feb/24 and the next month it will add a column automatically with Mar/24 based on invoice. After the last column, I have few columns in Excel (Not connected to query) where it shows formula. Since there is a division between two sets of data, the query doesn't use the same format I provided for the table to the new column. (Mar/24). I have to do the same formatting for the newly added column. Where as, if I have a blank column, the query applies the format to the new column keeping blank column at last.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.