Forum Discussion

Chainfire74's avatar
Chainfire74
Helper I
4 years ago
Solved

Grouping data in a column

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 gro...
Need Help
  • MahyarTF's avatar
    MahyarTF
    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

Chainfire74's avatar
Chainfire74
Helper I
4 years ago

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

lukiz84's avatar
lukiz84
Memorable Member
4 years ago

Sure, 

 

MyNewGroup := IF([myColumn] = "Blank" || [myColumn] = "Not Stated", "Unknown", [myColumn])

 

But MahyarTF's solution seems a little nicer.

  • Chainfire74's avatar
    Chainfire74
    Helper I
    4 years ago

    Thanks a lot!