PowerBI Create a table out of the selection of multiple field parameters

[schaetzles]

Hey guys, 

I need help for the following topic:

I have two Field Parameters with the following dimensions:

FieldParameter1                                                                        FieldParameter2:
Country                                                                                     Customer
Street                                                                                         Seller
Language                                                                                  Company


What i want to create is a table that contains all of the selected dimensions of the two parameters.

If i choose Country, Street and Seller my table should look like this:

Table
Country
Street
Seller




So far i tried everything from UNION and Crossjoin to measures and others.

Would be glad if someone could help me

Best regards

[Anonymous · Accepted solution]

Hi @schaetzles ,

I create a table as you mentioned.

Then I create two FieldParameters.

FieldParameter1 = {
    ("Country", NAMEOF('Table'[Country]), 0),
    ("Street", NAMEOF('Table'[Street]), 1),
    ("Language", NAMEOF('Table'[Language]), 2)
}

FieldParameter2 = {
    ("Customer", NAMEOF('Table'[Customer]), 0),
    ("Seller", NAMEOF('Table'[Seller]), 1),
    ("Company", NAMEOF('Table'[Company]), 2)
}

I think you can use the two FieldParameters tables for table reorganization.

Then you can get what you want.

Best Regards

Yilong Zhou

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

[audreygerred]

Make one field parameter with all of your dimensions in it. Then, the user will be able to select whatever dimesnions you have showing in the slicer for it. They can multi-select the items to show whichever combination they want. I would have a second field parameter (or calculation group) for measures.