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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

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
ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.