Issue with Parameter Fields

[keithjam]

I am trying to use a field paramter so I can toggle between two different variables on the y-axis.  

On top is a line chart of the first variable (E-0x).  Middle is a line chart of the sencond variable (E-2x).  The bottom is a line chart with the field parameter of E-0x or E-2x.  But, nothing shows up.  Any help would be appreciated.  

This is what I have selected for the field line chart.

[v-nmadadi-msft]

Hi @keithjam,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the community members for the issue worked. If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Thanks and regards

[v-nmadadi-msft]

Hi @keithjam,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If our responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-nmadadi-msft]

Hi @keithjam,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-nmadadi-msft]

Hi @keithjam,
Thanks for reaching out to the Microsoft fabric community forum.

In Power BI, implicit measures are automatically created when you drag a numeric column (like Sales Amount) into a visual, applying default aggregations such as SUM, AVERAGE, or COUNT. However, these cannot be used in certain scenarios, such as Field Parameters and SWITCH functions, because Power BI requires explicit calculations. This is where explicit measures come in manually defined using DAX, such as Total_Sales = SUM('Sales Table'[Sales Amount]). If you need an aggregated column in a field parameter, you must first create an explicit DAX measure (e.g., Total_E0x = SUM('Error Data'[E-0x])) instead of directly using the raw column. This ensures that Power BI can correctly interpret and apply the selected aggregation. Ultimately, explicit measures provide more control and flexibility, allowing dynamic switching between fields in visuals like line charts while avoiding errors.

Reference article for the above point: Use report readers to change visuals (preview) - Power BI | Microsoft Learn

Write a DAX query that first captures the slicer selection in a variable, then uses a SWITCH statement to dynamically sum the corresponding column (E-0x or E-2x) based on the slicer’s selection.

And then drag this measure to y-axis for the line chart, please try this method.

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thanks and Regards

[Anonymous · Accepted solution]

Hi @keithjam ,

                  It should work the way how you implemented. I assume that you have created 2 measures for E-0X,E-2x and added that in field parameter and used same parameter.

Can you try it in new page. Can you check whether any filters applied or not

Regards,

SK  

[keithjam]

When I right click on the Slicer Error Y-Axis and select "Show values of selected field" it only shows a count and doesn't give me the option of sum.