How to make my table only display Omron and Wago ?

[Paulyeo11]

Hi All

I have a COMPETITOR field name , Which display 5 competitors name :-

I like to break the competitor into 2 group , one group is very profitable and another group is not very profitable. 

Below table shown there are 5 competitor , i like to create a expression filed name = show_Omron_Wago  So that i can put at filter panel. ( See the red color box i have high lighted ).

My pbi file :-

https://www.dropbox.com/s/weg835g1dgkdaod/COMPETITOR_V010%20how%20show%20only%20wago%20and%20omron.p...

Paul Yeo

[AllisonKennedy · Accepted solution]

@Paulyeo11  Has this been solved now? Please let us know if you have any other questions, otherwise please mark all helpful solutions and kudos any helpful posts. 🙂 

[amitchandak]

@Paulyeo11 , Not very clear. You can create a measure like

new measure = calculate([measure], filter(Table, Table[COMPETITOR] in {"Omron","Wago"}))

[Paulyeo11]

Hi Amit

Thank you for your sharing. i get error msg when using your expression.

I have send you a PM. pls check.

[AllisonKennedy]

@Paulyeo11  You can add a visual or page level filter to select only Omron and Wago. 

OR, if you right click on the Competitor column and select "New Group" you can create a group for low profit and high profit groups. Then you can use that in your visuals and filters. 

[Paulyeo11]

Hi Allison

Thank you very much for sharing. The reasons i need to hard code the competitor is because in my actual PBI doc i have more then 30 competitors. So i need to plot those competitor net profit is increase and those are decrease.

Paul

[aj1973]

Hi Paul,

I join @AllisonKennedy and suggest that you create groups from your competitors. Go to Competitor field, right click and Add groups. Then use those groups as filters or in any of your visuals.

[Paulyeo11]

Hi AJ

Thank you very much , i just try in fact allison is right . this approach is much better.

I want to create one group only omron and wago with out Other it is possible ?

https://www.dropbox.com/s/weg835g1dgkdaod/COMPETITOR_V010%20how%20show%20only%20wago%20and%20omron.p...

Above my PBI file

Paul

[aj1973]

You just need to ungroup the Others from the group

Then use the filter Pane to get what want to see

[Paulyeo11]

Hi AJ

For those filter panel , when we tick , it will stick with the chart right ? i mean it will not change , unless some one go and change it right ?

[aj1973]

Correct, but you can hide the whole filter pane and it won't show up in the Power bi service if you don't want your users to act upon it.

[Paulyeo11]

Hi AJ

I though the user can just click on the red box i high lighted to view the filter panel ?

[aj1973]

Yes you can hide that pane in the service. 

In your desktop

Then Publish

Also you can hide the tabs as well.