Forum Discussion
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 result is "8891." Sometimes it's correct. If I just create a range from 0-99, it's always correct. However, I need the range up to 99999. Thanks, Stefan
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.
Hi stefantaust
This is the new Text Slicer:
https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-text-slicer
5 Replies
Hi stefantaust ,.
This is a know limitation in parameters (https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-what-if#considerations-and-limitations)
-
Parameters can only have 1,000 unique values. For parameters with more than 1,000 unique values, the parameter values will be evenly sampled.
This is what is happenning in your parameter that is making the evenly sampled values n the slicer.
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
StefanHi 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.
-
