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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Hao
Frequent Visitor

Is it possible to create a dynamic table based on a slicer's value?

Hi, there,

 

I have a slicer with a range between 1 to 1000. I want to generate a 1,000,000 rows table based on the selected value of the slicer. For example, if the selected value of the slicer is 1, then the table is generated by `GENERATESERIES(1, 1000000, 1)`; if the selected value is 5, then the table is generated by `GENERATESERIES(1, 1000000, 5)`; generally my requirement is:

  • The selected value of the slicer is used as "Increment Value."
  • The selected value changes and my table changes synchronously.

 

Thanks

 

Hao

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Hao , it is not possible to create a calculated table based on slicer value

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@Hao , it is not possible to create a calculated table based on slicer value

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Got it! Thanks!

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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