Column field have G1 to G16 how to make it display only G2 and G3 ?

[admin11]

Hi All

I have a column field , which having value label gtom G1 to G16 , i like to make it only display G2 and G3 only :-

i have try below :-

GROUP_TYPE_C = IF ( 'SALES'[GROUP_TYPE] = Blank(), "No",if(SALES[GROUP_TYPE] in {"G2","G3"},'SALES'[GROUP_TYPE], "Other"))

it does not working . see below image 

Below is my PBI sample file :-

https://www.dropbox.com/s/pwcsidetq8in7cy/PBT_V2021_392%20TI_SI_GL%20how%20to%20recode%20GROUP_TYPE%...

Paul

[PhilipTreacy]

@admin11 

Hi Paul,

Download PBIX

Create the slicer then in the Filters, restrict it to show only G2 and G3.

regards

Phil

[admin11]

@PhilipTreacy 

i Have already try using the filter , but some time it work , some time not working. those not working i decide to create slicer to filter.

Paul

[PhilipTreacy]

@admin11 

Hi Paul,

If you set the filtering as shown I can't think of any reason it shouldn't work.  You are saying in the filter only shows G2 and G3.  So it should only show G2 and G3.

Can you please link to a file where you've tried the filtering like this and it isn't working.

Thanks

Phil

[admin11]

@PhilipTreacy 

I refer to like below chart  , i set at filter only display G1 till G5 and G16.   

after i using filter pan to set it , then i create a bookmark = TARGET_SBU , and it work work fine from menu page. directly go to TARGET_SBU.

But then when i go to menu page and go TAGET Tab , and i thru TAGET Tab go to TARGET_SBU Tab , the chart will become un-sort .

@selimovd  have show me how to solve this problem different table , by un-tick All visual  :-

https://community.powerbi.com/t5/Desktop/How-to-force-PBI-sort-from-hi-to-lo-for-all-3-Table-in-one-...

As not easy to show the actual problem with my actual PBI foc.

Paul Yeo

[pranit828]

Hi @admin11 

You have displayed group type from table "Group Type" which is union of "sales" and "target_".

Now you have the group_type_c from only "sales" table and sales table doeen't have "G2" or "G3" at all so not able to display these in the slicer.

However if you create the same column on "Group TYPE" table and display it as a slicer you will bve able to see as your requirement.

PFB the file

[admin11]

@pranit828 

Thank you very much it work fine. 

Are you able to help me modify the expression , so that it will display 1 or 0 for user to select.

When l Click 1  G2 and G3 will be selected.

Paul Yeo 

[pranit828 · Accepted solution]

Hi @admin11 

you question is already asnsweres as per your ask. please accept that as answer.

However, below is the DAX 

GROUP_TYPE_C = IF ( ISBLANK('Group TYPE'[GROUP_TYPE]), "0",if('Group TYPE'[GROUP_TYPE] in {"G2","G3"},"1", "0"))

[admin11]

@pranit828 

Thank you very much , it work fine now