Перейти к содержимому

Dynamic Dimension + Dynamic Measure in Power BI | Let Users Pick BOTH the Axis AND the Measure!

Vanitha Gadge

0:00 / 0:00

Dynamic Dimension + Dynamic Measure in Power BI | Let Users Pick BOTH the Axis AND the Measure!

33 просмотра · 2 недели назад
Vanitha Gadge
175 подписчиков
33 просмотра · 2 недели назад
Build a Fully Interactive Power BI Chart Using 2 Field Parameters. Build a Fully Interactive Power BI Chart Using 2 Field Parameters (Field Parameters Combo). Take Field Parameters to the next level! In this tutorial, I'll show you how to let report users dynamically switch BOTH the chart axis (Category, Sub-Category, Region, Segment) AND the measure (Total Sales, Total Profit, Total Quantity) — all in one visual. Using the Superstore dataset, you'll learn how to: Create a "Pick a Dimension" Field Parameter (Category, Sub-Category, Region, Segment) Create a "Pick a Measure" Field Parameter (Total Sales, Total Profit, Total Quantity) Connect both parameters to a single bar chart for full interactivity Combine dimension switching with a multi-select measure table This is a powerful technique for building flexible, single-visual dashboards that replace dozens of static charts. 📊 Dataset used: Superstore (Orders table) 🛠️ Tools: Power BI Desktop – Modeling tab → New Parameter → Fields 🔔 Subscribe for more Power BI tips, DAX tutorials, and dashboard design tricks! #PowerBI #FieldParameters #DataAnalytics #PowerBITutorial #Superstore #BusinessIntelligence #DataVisualization #DAX