Forum Discussion

Rajeshwar-s's avatar
Rajeshwar-s
Regular Visitor
10 months ago
Solved

Fields Parameter accepting incorrect input values during What-if Analysis

Hi everyone, I've created a Fields Parameter (using Modeling > New Parameter > Fields) to generate a serial number with an incremental value of 1. The auto created DAX is: = GENERATESERIES(500, 1...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • danextian's avatar
    danextian
    10 months ago

    Hi Rajeshwar-s 

     

    This is a known issue with a single selection numeric parameter when there are many values to select from. Instead of single selection, use "Less than or equal to" and cover the grayed out area with a shape filled with a color that matches the background of the slicer.

     

Shubham_rai955's avatar
Shubham_rai955
Icon for Super User rankSuper User
10 months ago

This issue happens because Power BI might not be handling the manual input values correctly in the slicer for What-if analysis.

Try these steps:
- Check your Power BI version and update to the latest one.
- Make sure the slicer uses the same number format as your parameter (like no currency or special symbols).
- Check your computer’s region and language settings for numbers and currency symbols.
- If it still doesn't work, it could be a bug in Power BI. You can report this to Microsoft or look for help in the Power BI community forums.

 

Hope this helps!