Solved: Needed Help!!!

amar2arul · ‎06-11-2018

Hi All,

I have the data in the below format... Now i have to create a Drop down slicer with "output " format. when i click the dropdown, it should show whats therer in the output.

Is it possible in power bi?. when i used "grouping", only india and USA is there.. but i want both country and city together in the same drop down

v-chuncz-msft · ‎06-12-2018

@amar2arul,

You may select Unpivot Columns in the Query Editor or use UNION Function in DAX.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-chuncz-msft · ‎06-12-2018

@amar2arul,

You may select Unpivot Columns in the Query Editor or use UNION Function in DAX.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.