Forum Discussion

wsskb's avatar
wsskb
New Member
8 years ago

Dropdown based on info from a row NOT columns

Hi,

 

I am VERY new to powerbi, and need assistance.

 

I struggle with getting rows from a table (excel) converted in to a drop-down.

 

 

This is a simmilar example of the table. I have dates listed in the A-column, and destinations listed in rows.

 

I need the rows to be in a drop-down, however the only possibility is to have one drop-down for each row, so I am able only to show "dates" in one drop-down like this:

 

 

I need the dropdown to list the locations in the rows, so the table can be listed for only the specified location needed.

 

Appriciate time and assistance from you all.

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Image is not visible. Could you upload in the drive and send the link

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    You can use Edit Queries to create a new measured column with "Merge" option. With that, you have one column with all the information you need and use it to the dropdown.

     

    Regards.

    • wsskb's avatar
      wsskb
      New Member
      8 years ago

      I am not sure if I know the exact location you where describing. May you please give some screen caps?

       

      Thank you!

  • RolandsP's avatar
    RolandsP
    Icon for Resolver IV rankResolver IV
    8 years ago

    First, you need to Unpivot all the Location columns in the Query editor. You select all the location field and press Unpivot Columns. Then you have three columns in your table - Date, Location and Status.

    You can create 2 slicers in Power Bi. One for date and one for location. 

    If you really want that this information is in one slicer, you should create a new column that merges Date and Location columns. 

    • wsskb's avatar
      wsskb
      New Member
      8 years ago

      Hi RoldandsP,

       

      Thank you very much - it actually worked!

      I am just worried the table will be different after I refresh the documents with new information.

      I have not done that by now, but I will test some more :)

       

      Thanks again!