Request for Field Parameters Feature in Power BI Report Server (RS) Version

[Suntime]

Subject: Request for Field Parameters Feature in Power BI Report Server (RS) Version

Dear Microsoft Power BI Team,

Greetings!

I am a long-term user of Power BI, which is extensively utilized within our organization for creating and distributing critical business reports. We are highly impressed with the functionality and flexibility of Power BI, particularly the field parameters feature, which significantly enhances the interactivity and dynamism of reports.

The field parameters feature allows users to dynamically change the measures or dimensions being analyzed within a report, making the reports more adaptable and user-friendly. This feature has been widely applied and praised in both the Power BI service and desktop versions. However, we have noticed that this feature is not yet available in the Power BI Report Server (RS) version.

We understand that Power BI Report Server is typically used in enterprise environments where there are higher requirements for stability and compatibility. Nonetheless, we believe that introducing the field parameters feature in the PBI RS version will greatly enhance the reporting experience for enterprise users and further facilitate the decision-making process.

Here are some key benefits we believe the field parameters feature would bring to the PBI RS version:

1. Enhanced Interactivity: Field parameters allow users to customize report views according to their needs, thereby increasing user engagement and the practicality of reports.
2. Improved Flexibility: Users can easily switch between different data dimensions and measures without the need to redesign or modify the report.
3. Simplified Report Maintenance: By using field parameters, the number of reports that need maintenance can be reduced, as a single report can adapt to various data views and analysis needs through parameterization.
4. Support for Complex Analysis Scenarios: In enterprise environments, users may require in-depth analysis of data across multiple dimensions, and the field parameters feature will support these complex analysis scenarios.

We kindly request your team to consider introducing the field parameters feature in future versions of Power BI Report Server. We believe this enhancement will be well-received by the broad base of enterprise users and will help to solidify Power BI's leadership position in enterprise-level reporting solutions.

We look forward to working with your team to continue advancing and innovating Power BI. If you require any additional information or feedback, we are more than happy to provide it.

Thank you for your time and consideration.

收件人：Microsoft Power BI 团队

主题：建议在 Power BI Report Server (RS) 版本中提供字段参数功能

尊敬的 Microsoft Power BI 团队，

您好！

我是 Power BI 的长期用户，在我们的组织中广泛使用 Power BI 来创建和分发关键业务报告。我们对 Power BI 的功能和灵活性印象深刻，特别是字段参数功能，它极大地增强了报告的交互性和动态性。

字段参数功能允许用户动态更改报表中正在分析的度量值或维度，使得报告更加灵活和用户友好。这一功能在 Power BI 服务和桌面版本中得到了广泛的应用和好评。然而，我们注意到在 Power BI Report Server (RS) 版本中，这一功能尚未被提供。

我们理解 Power BI Report Server 通常用于企业环境，对于稳定性和兼容性有更高的要求。尽管如此，我们相信在 PBI RS 版本中引入字段参数功能将极大地提升企业用户的报告体验，并进一步推动决策制定过程。

以下是我们认为在 PBI RS 版本中提供字段参数功能的几个关键好处：

1. 增强的交互性：字段参数允许用户根据自己的需求定制报告视图，从而提高用户参与度和报告的实用性。
2. 提高灵活性：用户可以轻松地切换不同的数据维度和度量值，无需重新设计或修改报告。
3. 简化报告维护：通过使用字段参数，可以减少需要维护的报告数量，因为一个报告可以通过参数化适应多种不同的数据视图和分析需求。
4. 支持复杂的分析场景：在企业环境中，用户可能需要对数据进行多维度的深入分析，字段参数功能将支持这些复杂的分析场景。

我们恳请贵团队考虑在 Power BI Report Server 的未来版本中引入字段参数功能。我们相信这一改进将受到广大企业用户的欢迎，并有助于巩固 Power BI 在企业级报告解决方案中的领导地位。

我们期待与贵团队合作，共同推动 Power BI 的持续发展和创新。如果您需要任何额外的信息或反馈，我们非常乐意提供。

谢谢您的时间和考虑。

[Anonymous]

Thank you lbendlin

Hi, @Suntime 

Your idea is great. You can submit your current idea in ideas forum and vote for it so that Power BI can know more users need this feature and release it in future versions.

An alternative solution is proposed below.

Sample data based on Power BI:

First, I created a calculated table using the following DAX expression:

Dynamic axis Table = 
VAR _city = SELECTCOLUMNS(ADDCOLUMNS(VALUES(financials[Country]),"Target","Country"),"Target",[Target],"Target detial",'financials'[Country])
VAR _year = SELECTCOLUMNS(ADDCOLUMNS(VALUES(financials[Year]),"Target","Year"),"Target",[Target],"Target detial",'financials'[Year])
RETURN UNION(_city,_year)

Use the following DAX expression to create a measure:

Data = 
IF(HASONEFILTER('Dynamic axis Table'[Target]),
SWITCH(TRUE(),
    SELECTEDVALUE('Dynamic axis Table'[Target])= "Country",CALCULATE(SUM(financials[ Sales]),TREATAS(VALUES('Dynamic axis Table'[Target detial]),'financials'[Country])),
    SELECTEDVALUE('Dynamic axis Table'[Target])= "Year",CALCULATE(SUM(financials[ Sales]),TREATAS(VALUES('Dynamic axis Table'[Target detial]),'financials'[Year]))
),
ERROR("don't select two x axis")
)

Use these fields in your chart:

Through the slicer we can dynamically switch the coordinate axis to realize the role of the field parameter:

Regarding the dynamics of the metrics, first I have the following two metrics:

Create the following Table:

Create the following metric:

Data measure = SWITCH(TRUE(),
    SELECTEDVALUE('Dynamic Measure Table'[Measure]) = "Sales YTD",[ Sales YTD],
    SELECTEDVALUE('Dynamic Measure Table'[Measure]) = "Sales running total",[ Sales running total]
)

To dynamically switch measure values ​​in a slicer:

The only shortcoming of this approach is that it only supports single selection. Other functions are similar to field parameters, allowing users to continue to switch dimensions/measures freely.

Best Regards

Jianpeng Li

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

[Suntime]

This workaround using measures can only be applied to the value area of Power BI matrix (table) visual controls, not to the row and column areas. What I need is automatic field switching for the row and column areas.

这种采用度量值的变通解决方法，只能应用 POWER BI 矩阵(表格)视图控件的值区域，不能应用到行、列区域，我需要的是作行、列区域的自动字段切换

[lbendlin]

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com

[Suntime]

Thank you, it has already been submitted to https://ideas.fabric.microsoft.com.

[Anonymous]

Hi @Suntime 

Indeed, this workaround is not a complete replacement for field parameters. Can you share your ideas URL here? So that other forum users can vote for your ideas?
You can mark your ideas as solutions, so that others can quickly find your post and vote for it when they are looking for solutions!

Best Regards

Jianpeng Li