Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I am looking to group or bucket all the below customer sizes not P1-P5 into the "unknown" bucket.
When I click two or more customer sizes and right click the "group" button is grayed out. Is this because my data source is a sales cube so I can not edit? Does any know why the group button is grayed out or know a dax measure to use instead of group button?
I don't need to create hierarchy or pivot style drill down, just need to only have P1-P5 customers displayed.
Customer Size |
P5 |
P4 |
P3 |
P2 |
P1 |
Unknown |
Retail |
7 |
2 |
3 |
4 |
The feature (grouping/binning) does not work with any live connection to PowerBI/SSAS semantic models and in PowerBI Service - only in thick reports in PowerBI Desktop - so it is pretty much useless for any enterprise reporting. Please cosider upvoting the feature: Microsoft Idea and here: Microsoft Idea
Thanks for the reply but the group button is still grayed out. WOuld this be able to be solved by using DAX?
Yes I can create a new measure using my live connection. Do you which type of function I would need to use?
Customer Size | Desired output column |
P5 | P5 |
P4 | P4 |
P3 | P3 |
P2 | P2 |
P1 | P1 |
Unknown | Unknown |
Retail | Unknown |
7 | Unknown |
2 | Unknown |
3 | Unknown |
4 | Unknown |
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
10 | |
6 |