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.
Hi, I'm fairly new to Power BI.
I have a colum where the options are White, BME, Not Stated and Blank, within that column I want to combine the Not Stated and Blank data together to create a group called "Unknown".
Thanks in advance.
Solved! Go to Solution.
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
Hi,
just add a calculated column to your table where you do something like this:
MyNewGroup := IF(ISBLANK([myColumn]) || [myColumn] = "Not Stated", "Unknown", [myColumn])
And place this new column on your table/matrix/whatever
br
Thanks for your reply. Me being silly, the cell isn't blank but the word in the cell is "Blank". Do you know what the formula would be for this?
Thanks
Sure,
MyNewGroup := IF([myColumn] = "Blank" || [myColumn] = "Not Stated", "Unknown", [myColumn])
But @MahyarTF's solution seems a little nicer.
Thanks a lot!
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 |
---|---|
100 | |
100 | |
76 | |
68 | |
62 |
User | Count |
---|---|
142 | |
106 | |
103 | |
85 | |
70 |