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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
GAPER
Post Patron
Post Patron

Question about creating a 0 - 10 slicer

GAPER_0-1696923976900.png

 

I used the formula 

Top N = GENERATESERIES(0,10,1
 
but it's giving me an error. What might be the reason?
 
Thanks

 

1 ACCEPTED SOLUTION
Idrissshatila
Super User
Super User

Hello @GAPER ,

 

you should create this as a table not a measure

Idrissshatila_0-1696925099755.png

 

Idrissshatila_1-1696925125302.png

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




View solution in original post

5 REPLIES 5
Uzi2019
Super User
Super User

Hi @GAPER ,
If you want to create slicer of numeric range  and want to use in your calculation so you can go for parameter.

Uzi2019_0-1697091692015.png

Uzi2019_1-1697091785775.png

After creating parameter it will look like this on report.

Uzi2019_2-1697091938526.png

you can use the values of this parameter directly in any calcuation.

If my post helps you please appreciate with kudos and please accept my solution!

 

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!
Idrissshatila
Super User
Super User

Hello @GAPER ,

 

you should create this as a table not a measure

Idrissshatila_0-1696925099755.png

 

Idrissshatila_1-1696925125302.png

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




GAPER
Post Patron
Post Patron

GAPER_0-1696924863038.png

 

 

Same not working

Hello @GAPER ,

 

Did you create it as a table or a measure ?

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Idrissshatila
Super User
Super User

hello @GAPER ,

 

try converting the visual to a table, or add the measure to a table.

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

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

Top Kudoed Authors