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 da...
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!