Forum Discussion
Grouping data in a column
- 4 years ago
Hi,
in Power BI, click on the column (ellipsis icon near to the column (...)), then select New Group,
On the shown page, select the value(s) in the left hand and put it in the right section by clicking Group Button or double click on the value :
- Double Click on the title in the right hand and rename it as you want
Then click Ok, Now you have a group of 'Blank' and 'Not Stated' value with 'Unknown' name and could use this new column (group column) in you visuals
Hi,
in Power BI, click on the column (ellipsis icon near to the column (...)), then select New Group,
On the shown page, select the value(s) in the left hand and put it in the right section by clicking Group Button or double click on the value :
- Double Click on the title in the right hand and rename it as you want
Then click Ok, Now you have a group of 'Blank' and 'Not Stated' value with 'Unknown' name and could use this new column (group column) in you visuals