Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Ungrouped values missing when trying to create a Group

Hi everyone,

 

I am trying to create some groups based on the values of one specific column, but when I try to group them there is one value that is missing. 

 

I have refressesh everything and it is still not showing.

 

Do you know why and how can i solve it?

 

Many thanks in advance,

Marina 

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi all,

    Although I refreshed the Power BI Desktop and the Preview in the Power Query editor I had to reboot my computer so the recent added data appeared as ungrouped value.

     

    Many thanks all for your time,

    Marina

2 Replies

  • Anonymous , if you using switch if, make sure you have else part. Return "Other" these

     

    Switch(True(),

    [Col1] <10 , "< 10 ",

    [Col1] <20 , " 10 -20 ",

    // other conditions

    "Other" //else

    )

     

    If this does not help
    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi all,

    Although I refreshed the Power BI Desktop and the Preview in the Power Query editor I had to reboot my computer so the recent added data appeared as ungrouped value.

     

    Many thanks all for your time,

    Marina