Forum Discussion
Return two values from two different measures, based on one selected column.
Hi,
I found this with field parameters Using SELECTEDVALUE with Fields Parameters in Power BI - SQLBI. I would need to use summarize and that's not optimal.
I created a table instead, together with a switch and now it works.
Hi SLJN ,
According to your requirements description, what you want to achieve is to display the displayed fields in your line chart according to the user's choice of the slicer on the report page according to the user's selection, such as when the user chooses to scroll 30, a line chart with two lines will appear, that is, actual production and planned production, for this requirement I think the best solution at present is to try to use Power BI's new preview function field parameter in recent months, It can support the display of specific visuals in your report according to the selection in the field slicer, you can refer to this official document to explore your solution:
Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
I found this with field parameters Using SELECTEDVALUE with Fields Parameters in Power BI - SQLBI. I would need to use summarize and that's not optimal.
I created a table instead, together with a switch and now it works.