Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
oakfootballclub
Helper IV
Helper IV

how to create multiple dimensions in field paramater?

Hi experts, I created a field parameter and now I want to create mutiple dimension for one parameter of field parameter, for example, add the city under region, when I click region then I can expand the city in matrix, do you have solutions?

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @oakfootballclub ,

Drill down to the city in the region by clicking on the field parameter, for now it looks like a hierarchy can be used.

Below is my table:

vxiandatmsft_0-1717723536734.png

This is my field parameter

vxiandatmsft_1-1717723555103.png

You can create a hierarchy :

vxiandatmsft_2-1717723633351.png

Drag the hierarchy you created from the Fields pane into the Rows area of the Matrix visual.

vxiandatmsft_3-1717723661509.png

Drill down to the city in the region by clicking on the field parameter, for now it looks like a hierarchy can be used.

Best Regards,

Xianda Tang

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

2 REPLIES 2
Anonymous
Not applicable

Hi @oakfootballclub ,

Have you solved your problem, if so please mark the correct answer as answer. Thank you.

Best Regards,

Xianda Tang

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

Anonymous
Not applicable

Hi @oakfootballclub ,

Drill down to the city in the region by clicking on the field parameter, for now it looks like a hierarchy can be used.

Below is my table:

vxiandatmsft_0-1717723536734.png

This is my field parameter

vxiandatmsft_1-1717723555103.png

You can create a hierarchy :

vxiandatmsft_2-1717723633351.png

Drag the hierarchy you created from the Fields pane into the Rows area of the Matrix visual.

vxiandatmsft_3-1717723661509.png

Drill down to the city in the region by clicking on the field parameter, for now it looks like a hierarchy can be used.

Best Regards,

Xianda Tang

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

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors