how to show a filtered dimension on x -axis looker

[Richard_Georgie]

Hello Community ,

Is there a way to show in the visualization /column a filtered dimension on x-axis .

i have the following 

I need to show Connect status something like this : 

Closest i found is with pivoting the Supplier Status Column ,however it breaks the whole column (Supplier Status) .

I tried custom dimeonsion ,measure ,table calculation however no good