Forum Discussion
EslamEzzat
2 years agoNew Member
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
EslamEzzat , You have a load drop-down source in power bi.
Or you have to load a table with all those values
1 Reply
- amitchandakSuper User
EslamEzzat , You have a load drop-down source in power bi.
Or you have to load a table with all those values