The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I am not sure why this is happening.
I made two groups of values between 5-10, and 11- above, and I want to display these two groups with ungrouped values 0-4.
I am not able to unselect the "Include Other group".
There is a message also popping with (i) next to the click section in the bottom right that takes me to this link about grouping.
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-grouping-and-binning/
Please help!! (IMage below)
unable to uncheck the include other group
Solved! Go to Solution.
@ngupta,
It is not possible to unselect include other group when creating groups for numerical fields. Please change the data type of your field to Text, then you are able to unselect include other group when creating groups for the field.
Regards,
Lydia
@ngupta,
It is not possible to unselect include other group when creating groups for numerical fields. Please change the data type of your field to Text, then you are able to unselect include other group when creating groups for the field.
Regards,
Lydia
Hello, I want to ask how to make another group uncheck the check box
Hi,
I have my column as text data type, yet I still can't untick it. Any tips?
Thanks Lydia,
This works, I changed the format to text and now I can group and see non-grouped items too.
One additional follow up question:
For a stacked bar chart, the group always takes the lowest place on the graph. I want the group to be on the top. For eg: my data has no. of bids for procurement and there are some with 2, 3, 4 and 5+(5-15) bids. I want to present with 5+ bids group to be on the top and followed by a descending order or 4,3,2. but I am getting the following order from top to bottom= 4, 3, 2, 5+. (see below)
I tried creating separate column and to sort by that column, i have bids from 5-15 range, and even if I create a column (for sorting ), to capture as many in the range, still the blank/uncaptured data is at the bottom. I don't want to write if command for all possible number of bids. Any suggestions.
@ngupta wrote:Thanks Lydia,
This works, I changed the format to text and now I can group and see non-grouped items too.
One additional follow up question:
For a stacked bar chart, the group always takes the lowest place on the graph. I want the group to be on the top. For eg: my data has no. of bids for procurement and there are some with 2, 3, 4 and 5+(5-15) bids. I want to present with 5+ bids group to be on the top and followed by a descending order or 4,3,2. but I am getting the following order from top to bottom= 4, 3, 2, 5+. (see below)
I tried creating separate column and to sort by that column, i have bids from 5-15 range, and even if I create a column (for sorting ), to capture as many in the range, still the blank/uncaptured data is at the bottom. I don't want to write if command for all possible number of bids. Any suggestions.
Because you changed the field to be text the sorting works different.
For numbers it is 1, 2, 3 … 10, 11 etc. For text it will be 1, 10, 2, 20 3, 30.
To make this more clear AB will come before C even when C has less characters. This is the same why 10 comes before 2.
So to solve this edit the title of the group to start with an index "1) 10 & 11 & 12 & …"
@ngupta,
Would you mind sharing me the PBIX file so that I can test? You can post PBIX file to OneDrive and post shared link of the file via Private Message. Do mask sensitive data before uploading PBIX file.
Regards,
Lydia
Sorry about the delay, I will share the file in the next few days. Dealing with some data privacy issues.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
140 | |
112 | |
111 | |
77 | |
62 |
User | Count |
---|---|
264 | |
129 | |
123 | |
99 | |
93 |