The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
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
User | Count |
---|---|
160 | |
110 | |
96 | |
86 | |
75 |
User | Count |
---|---|
159 | |
136 | |
133 | |
81 | |
61 |