Parameters using Excel as data source

[Vijaykumar_shan]

I'm using Excel as Data source

1. I have created dropdown parameters - Actual with values such as fst 0+12,fst 1+11,fst 2+10

2. created calc_column = IF (forecast_column=Actual,savings,0)

3. When I drag parameter to report using slicer I'm not getting the drop down (it only shows one selected value)

4. how to bind parameter using query editor so that calc_column changes when user selects different values from drop down parameter

Please suggest

[Anonymous]

Hi, @Vijaykumar_shan 

Based on your question, here are my answers.

In Power Query, create a new parameter.

You can create multiple parameters for different needs. I think you can also try New parameter under Modeling and then select Fields to write the parameter.

If neither of the above methods work I hope you can provide me with the data so that I can analyze it further.

How to Get Your Question Answered Quickly 

Best Regards

Yilong Zhou

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

[Vijaykumar_shan]

Hello,

My dropdown Parameter(Actual_parameter) needs to have values (fst 0+12,fst 1+11,fst 2+10) when user selects this value the column needs to change actuals=IF (forecast_column=Actual_parameter,savings,0)

Actual	Forecast_column
100	Fst 0+12
200	Fst 1+11
300	Fst 2+10
400	Fst 0+12
500	Fst 1+11

[amitchandak]

@Vijaykumar_shan ,Based on what I got

Create measures and use field parameters for that.

Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
Field Parameters- Conditional Formatting
: https://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdf
Power BI Field Parameters, Keep Axis Sort intact| Always Sort on X/Categorial Axis: https://youtu.be/GfBrB6czByw

[Vijaykumar_shan]

Hello,

My dropdown Parameter(Actual_parameter) needs to have values (fst 0+12,fst 1+11,fst 2+10) when user selects this value the column needs to change actuals=IF (forecast_column=Actual_parameter,savings,0)