Fabric Plan Community Logo
Sign in

Replicating Power BI Field Parameter Functionality in Intelligence Sheets

Started by EmmaCarter · 1 month ago · 1 reply · 85 views
EmmaCarter Participant
1 month ago

We have a Power BI report where we use Field Parameters to provide users with dynamic analysis capabilities. For example:

Users can switch chart dimensions such as Product, Region, Customer, or Category.
Users can also change the measures displayed in matrices, such as YTD, QTD, MTD, or different versions like Actuals, Budget, and Forecast.

We're exploring the Intelligence Sheet in Plan and would like to understand whether a similar approach is supported there.

Question:
Can Power BI Field Parameters be used within the Intelligence Sheet to dynamically switch dimensions and measure selections? If not, what is the recommended way to enable comparable user-driven dimension and measure switching in the Intelligence Sheet?

Any guidance, best practices, or examples would be greatly appreciated.

Up
0
1 Reply
Accepted answer
Ramya B
Manager - Customer Success · Lumel Technologies · 1 month ago
Best Answer

You can use the field parameters created in PowerBI in the Intelligence sheet. You can use them in the superfilter to filter/change the dimensions. You can also create parameters inside the Planning item to create buttons or lists or number sliders. You can check this video to know more about parameters in Intelligence sheet - Parameters in Fabric Plan - Fabric Plan | Community for Enterprise Planners

Up
0

Viewing 1 replies (of 1 total)

Fabric Plan
Enterprise planning, integrated with PowerTable and Intelligence, native to Microsoft Fabric. Co-engineered with Lumel.
BUILT ON MICROSOFT FABRIC
CERTIFIED BY
Fabric Planning is certified by IBCS
Microsoft, Azure, Copilot, Excel, Fabric IQ, Microsoft Entra, Microsoft Fabric, Microsoft Teams, OneLake, Outlook, Power Automate, Power BI and SharePoint are trademarks of the Microsoft group of companies. IBCS is a registered trademark of IBCS Association. All other trademarks are the property of their respective owners.

This community is operated independently by Lumel. Nothing on this site constitutes a representation or warranty by Microsoft.