Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello
I need help to get a report that I can drill down into:
On the bottom level I have different accounts ranging from 3000 to 9999, with 3 columns of values.
On the second level I'm grouping them like this:
3000-3099
3100-3199
3200-3299
.....
On the top level I need summering groups like this:
3000-3299
3000-3599
3000-3999
3000-3599 and 4000-4299
3000-4599
....
3000-9999
Is this possible to do with Power BI?
Bottom level is not a problem, nor the second level but I'm lost with the top level?!
On the second level I used this that I found in a forum
(vals) => let ValBucket = { {(x)=>x<10, "0-9 members"}, {(x)=>x<25, "10-24 members"}, {(x)=>x<50, "25-49 members"}, {(x)=>true, "50+ members"} }, Result = List.First(List.Select(ValBucket, each _{0}(vals))){1} in Result
I did of course changes to the code, like this :
{(x)=>x<3099, "group1"},
Could you please post a screenshot about the expected report? Do you want to show 3000-3299,3000-3599. 3000-3999….in the first level of X-axis, then after you drill down the report, the second level will show 3000-3099,3100-3199,3200-3299… in X-axis?
Regards,
Lydia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
77 | |
69 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |