Forum Discussion
Parameter single Value
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
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.
Thank you, it works 🙂
What is the name of this Visual?
