Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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:
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:
Is this not possible, and if so any work arounds?
@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.
⭕ 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:
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.:
Hope that clarifies it better?
User | Count |
---|---|
16 | |
15 | |
14 | |
12 | |
11 |
User | Count |
---|---|
19 | |
15 | |
14 | |
11 | |
9 |