Forum Discussion

EslamEzzat's avatar
EslamEzzat
New Member
2 years ago
Solved

transfer drop-down list

Hello,

 

On my Excel sheet, there is a cell with a drop-down list with each month that changes the rest of the data when l change that month.

 

How can l transfer that data with that drop-down menu to the power bi, when l do that, the cell keeps the last month l picked without a drop-down to make something else

 

Ex: my drop down was Jan and l can't pick it or drop a list from it to choose Feb.

 

Do I have to make a dummy column with all months or is there something else similar like the drop-down list

1 Reply

  • EslamEzzat , You have a load drop-down source in power bi.

     

    Or you have to load a table with all those values