Ungrouped values missing when trying to create a Group

[Anonymous]

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 · Accepted solution]

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

[amitchandak]

@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.