Power Query Editor - fill in word to watch for

MDN5551 21 Reputation points
2021-01-19T23:50:47.77+00:00

Hi all,

I am looking for the solution to this issue. I am on Power Query Editor and I typed a spectific title to filtered out but it is not available. I expected that because there is no data in it. It eventually will show up once someone fill out the form. Is there a way to add the title manually (or Ghost)? This will help to refresh data to see if someone filled out the form, yet. If someone did then it would show up with "ghost" title that I typed the title manually. Please let me know if need clarification.

Matthew

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
35,815 questions
Accepted answer
  1. Lz._ 8,986 Reputation points
    2021-01-24T16:39:34.793+00:00

    Hi @MDN5551 /Matthew

    Assuming Table1 in Excel for which you want to keep the "Blue" color that doesn't exist yet:
    59952-xl-table1.png

    Once loaded in Power Query it should look like:
    59887-pq-table1.png

    1/ Go the Home (tab) > Advanced Editor - the query should look like:
    59950-pq-initialcode.png

    2/ Add a comma at the end of the #"Changed Type" step + [Enter]
    3/ Add the following step: 

    FilteredColor = Table.SelectRows(#"Changed Type", each [Color]="Blue")

    4/ Replace #"Changed Type" after in with FilteredColor

    Your final query code should look like:
    59896-pq-finalcode.png

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. MDN5551 21 Reputation points
    2021-01-23T17:30:32.213+00:00

    Yes, you got it. For example, if I want the color Blue under Color column but the blue value isn't available yet but it will.

    Eg.

    Worksheet have three tabs with name "Yellow", "Blue", and "Red". So, I set up each tabs using the Power Query to select to filter Yellow, Blue, etc. For the blue tab I tried to type "Blue" value under the color column but this value isn't exist in the source table, yet. I would like to be able to keep "Blue" and eventually later the data will show up once it is available in the source table.

    Matthew

    0 comments
  2. third one 1 Reputation point
    2022-12-29T14:32:29.703+00:00

    Worksheet have three tabs with name "Yellow", "Blue", and "Red". In this way, I set up every tabs utilizing the Power Question to choose to channel Yellow, Blue, and so on. For the blue tab I attempted to type "Blue" esteem under the variety section yet this worth isn't exist in the source table, yet. I might want to have the option to keep "Blue" and in the end later the information will show up once it is accessible in the source table.

    0 comments