How to make my Segment Report only Display 2 instead of 4 row ?

[admin11]

Hi All

I have a SEGMENT_C field , it have below 4 value label:-

Now the report look like below :-

SEGMENT_C............. SALES_

Marine........................... 3642

Oil & Ga........................ 1440

Related Coy...................4450

Semicon/Electronic....19224

Total ................................28756

How to make it look like below :-

SEGMENT_C............. SALES_

Other..............................24306

Related Coy.................4450

Total ..............................28756

Below is my PBI sample file :-

https://www.dropbox.com/s/ageeb7resqpsysk/PBT%20Create%20Christine%20Ho%20report.pbix?dl=0

Thank you

Paul

[amitchandak · Accepted solution]

@admin11 , You have to create a new column

Segement_c = Switch ( True() ,

[Segment_c] ="Related Coy" ,"Related Coy",

"Other"

)

[admin11]

@amitchandak 

Now your skill improve a lot. Thank

Paul