Forum Discussion
Display mutliple columns under a Name (No hierarchy /No grouping)
HI Tahreem and Zhengdong Xu,
The solution is sorted without creating DAX / Table. In data Modelling for cube, below are the steps.
1. we have to select device_code (under my scenario here), Just type name "More Fields" under Display Folder and make it visible . Note: Type the text More Fields without quotes.
2. CTRL+CLICK the remaining fields which to be listed below, and give the name as More Fields\SubDevice and make the remaining fields as Visible here too. Note: After \, the name can be any.For my scenario, i have kept the name as SubDevice.
3. On Saving, we will see multiple sub folders in desktop, once published, all the fields will show under 1 name "More Fields". Here it go!!! Thank You Both for considering the post and have given your valuable inputs too.
HI Tahreem and Zhengdong Xu,
The solution is sorted without creating DAX / Table. In data Modelling for cube, below are the steps.
1. we have to select device_code (under my scenario here), Just type name "More Fields" under Display Folder and make it visible . Note: Type the text More Fields without quotes.
2. CTRL+CLICK the remaining fields which to be listed below, and give the name as More Fields\SubDevice and make the remaining fields as Visible here too. Note: After \, the name can be any.For my scenario, i have kept the name as SubDevice.
3. On Saving, we will see multiple sub folders in desktop, once published, all the fields will show under 1 name "More Fields". Here it go!!! Thank You Both for considering the post and have given your valuable inputs too.