Forum Discussion

stefantaust's avatar
stefantaust
Helper I
1 year ago
Solved

Parameter single Value

Hello, I created a dataset using parameters and displayed the slicer. I have the value displayed as "Test Wert". However, it often doesn't display the exact value. If I type in the value "8888," the...
Need Help
  • MFelix's avatar
    MFelix
    1 year ago

    Hi stefantaust ,

     

    I believe you can use a workaround:

    On the parameter table add a new column with the following code

    Text Values = FORMAT(Parameter[Parameter], "00000")

    This will give you the following table:

     

    Create a new measure on the parameters: 

    Parameter Value Min = IF(ISFILTERED(Parameter[Text Values]), MIN(Parameter[Parameter]))

     

    Now use the new Text slicer to do your calculation:

     

    Please see file attach.

     

stefantaust's avatar
stefantaust
Helper I
1 year ago

Hi,
Thanks for the feedback. Then I have a problem if I need up to 99,999 values. I need an input field, but unfortunately, Power BI doesn't provide that.
Thanks
Stefan

MFelix's avatar
MFelix
Super User
1 year ago

Hi stefantaust ,

 

I believe you can use a workaround:

On the parameter table add a new column with the following code

Text Values = FORMAT(Parameter[Parameter], "00000")

This will give you the following table:

 

Create a new measure on the parameters: 

Parameter Value Min = IF(ISFILTERED(Parameter[Text Values]), MIN(Parameter[Parameter]))

 

Now use the new Text slicer to do your calculation:

 

Please see file attach.