Verified by DataSimHQ

Analyst

Bashirat Oyekunle

Senior Analyst

Project

Dynamic Axis with Field Parameters

Meridian Retail Co. · Power BI · intermediate

The brief

Ngozi keeps switching between wanting to see different metrics on the same chart. Instead of rebuilding the chart each time, set up field parameters so she can switch the metric herself.

Create a field parameter called Performance Metric containing these measures: Revenue (₦), Gross Margin %, and Discount Impact (₦).

Add a second field parameter called Breakdown Dimension so she can toggle between: Category and Store Region.

Build a single report page using both parameters — the chart should update dynamically when either slicer is changed.

Independent grading

95/100

Achieved 1 Nov 2026

Graded automatically against a fixed rubric for this task. Feedback and submitted work remain private to the analyst.

What is DataSimHQ?

A practice platform where analysts complete graded business tasks for simulated companies in SQL, Power BI, and Excel, and build a portfolio of proven work. Learn more