Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
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?
Solved! Go to Solution.
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:
This is my field parameter
You can create a hierarchy :
Drag the hierarchy you created from the Fields pane into the Rows area of the Matrix visual.
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.
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.
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:
This is my field parameter
You can create a hierarchy :
Drag the hierarchy you created from the Fields pane into the Rows area of the Matrix visual.
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.