transfer drop-down list

[EslamEzzat]

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

[amitchandak · Accepted solution]

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

Or you have to load a table with all those values