I have created a parameter on Posting Period: Values for posting period are 001,002,003,.........011,012.
When I create a parameter and enter the current value ass "001" and click on OK, it changes to "1".
The data in my database is 001 and passing just 1 is giving me an error.
I need to change the parameter data type to Text(ABC) rather than whole number(123) to accept 001 as value and pass to the DB to fetch the data.
Can someone please let me know how to achieve this?
Go to Solution.
Hi @POS3002 ,
When you create "Posting Period" parameter, it is needed to change the type to "Text", not "Any".
You can modify the type according to the following steps:
1. Manage Parameter.
2. Change the Type of Parameter from "Any" to "Text".
3. Enter "001" to current value.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.