Display mutliple columns under a Name (No hierarchy /No grouping)

[SUGISUGAN]

HI,

I am building a cube for which in my dimension tables where i have to show fields as a hierarchy and at the same time, the fields must be shown in single.

Eg : i have fields name Device Name, Device Make, Device Model, Device Type

Expected Output : Device Hierarchy -> Device Name, Device Make, Device Model, Device Type

                              More Fields -> Device Name, Device Make, Device Model, Device Type

How to bring it up.? kindly suggest.. i need a More Fields Name just to populate where we can drag and drop the columns under it for individual data view

[SUGISUGAN · Accepted solution]

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.

[Tahreem24]

@SUGISUGAN Not sure whether I understood you question properly or not. Based on my understanding, you want one hierarchy as "Device Hierarchy" which will contain Device Name, Device Make, Device Model, Device Type fields? If yes, so you can create hierarchy and keep adding these fields. Link 

Next question, what I understood is you want to show all these fields in together? If yes so you can concatenate all these fields with "&" sign and separated by "-" as a new calculated column.

New Column = [Device Name] & "-" & Device Make & "-" & Device Model & "-" & Device Type

I hope this may help you!

[SUGISUGAN]

Hi Tahreem,

Thank you first of all for the quick response. First one, creating hierarchy, i was able too. But for the second, i want to show individual one (not concatenated) one below the other but not as hierarchy.. just like an expand/collpase option which it can be seen in cube.

Example as shown : more fields shoultnt be a hiearchy..

[Tahreem24]

@SUGISUGAN For "More Fields", either you can accomplish with creating hierarchy (which you already did) OR you can create a new table and add only these fields.

New Table =  SELECTCOLUMNS(YourTableName,"DeviceName",[Device Name],"DeviceMake",[Device Make])

Note: Add more fields in above DAX as per your requirement.

[SUGISUGAN]

HI Tahreem,

below is the error i am getting.. 

[Anonymous]

Hi @SUGISUGAN 

About this error, the DAX formula is to create a new table, so you should not click the new column button.

You can click the new table button and paste the formula to create a new calculated table:

-------------------------------------------------------------------------------------------

But as far as I know, the power bi currently doesn't support the feature that creating hierarchies that can be expanded or collpased, only hierarchies like this:

Maybe you can submit your idea on Microsoft Fabric Ideas which is a platform that specializes in collecting product ideas from users:

Home

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SUGISUGAN]

HI Zhengdong Xu, 

i have created with new table , but still, i have to show my new table under the name VD_DEVICE_DIM.. its populating as separate /standalone at the top.. can you kindly assist how to bring it..

Current representation : 

Expected View like this: the new table must fall within the main VD_DEVICE_DIM

[Tahreem24]

@SUGISUGAN That is not doable to bring a new table under any exisiting tables.

Quick question, What's the purpose of bringing this new table under exiting table?

[SUGISUGAN]

HI Tahreem,

Thank you for replying back. i need this under MAIN table for cube purpose, where the user wants to see the value against hierarchy level or with individual column level. There are dimensions where the individual columns crossing 10, which will be lengthy on seeing in cube mode.. I just need a common name to club individual fields together under every dimension.