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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
DataCruncher123
Frequent Visitor

Parameter doesnt work

I have created the following calculated column "Level" based on a parameter that can be a number from 4-24, selected in the slicer in report view (see further down). The formula is quite simple, it just categorizes the table by "count" values into 4-24 same sized groups:

 

DataCruncher123_0-1703928894028.png

 

 

My ideas is that when changing the parameter slicer, it adjusts the table on the right here to the number of levels I entered on the left, but nothing happens:

 

DataCruncher123_1-1703928587610.png

Is this not possible, and if so any work arounds?

2 REPLIES 2
Fowmy
Super User
Super User

@DataCruncher123 

While crafting a table or calculated column in Power BI, capturing slicer selections in real-time isn't feasible. Power BI constructs tables and columns before making them available on the report canvas. To assist you more effectively, kindly explain your requirements clearly, furnish sample data, and outline the expected outcome. This will enable a tailored solution to meet your specific needs. An approach using Measures should work in your case.



Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

thanks for the feedback @Fowmy 

 

this would be an example data table given, one column with article code, and another with how many requests it has in a given time:

DataCruncher123_0-1703964311497.png

 

And this is what I need in the report view and to be changed dynamically. I want to create X categories that are of same size/number of articles. Where the first categories always sums the requests of the articles with most requests, second categories with the next ones etc.:

DataCruncher123_1-1703964373178.png

 

Hope that clarifies it better?

 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.