Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
@admin11 , You have to create a new column
Segement_c = Switch ( True() ,
[Segment_c] ="Related Coy" ,"Related Coy",
"Other"
)
@admin11 , You have to create a new column
Segement_c = Switch ( True() ,
[Segment_c] ="Related Coy" ,"Related Coy",
"Other"
)
User | Count |
---|---|
94 | |
83 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
62 |