Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

DAX Parameter: When i type 0 Parameter shows -1

Hi, i am using following DAX Parameter.

Parameter = GENERATESERIES(-999; 999; 1)
When i type 0 in the slicer it changes it to -1.
When i type 2 in the slicer it changes to 1.
When i type 3 in the slicer it works and shows 3.
 
Why is it not taking my number correctly?
3 REPLIES 3
Tara_
Helper II
Helper II

Hi @Anonymous 

 

I couldn't reproduce your issue, mine worked fine. However can you check if you are using the latest Power BI version and also check the below

https://community.powerbi.com/t5/Desktop/Parameter-Slicer-shows-incorrect-value/td-p/625942

Hope this helps

 

Anonymous
Not applicable

In the link you posted I found a little workaround by using "between" and typing in 0 and 0.

 

I have Version: 2.66.5376.2521 64-bit (Februar 2019).

Using single Value is not working still autocorrects 0 to -1.

Is this working in a newer Version?

Yes, it is working fine on my version with no autocorrect. I have desktop version December 2019, I recommend you upgrade.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.