Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
I am working on a project that shows credit distribution over work areas. My raw data contains customer number, risk amount,branch and customers area of work information. I wrote a measure to see what is the risk distribution over sectors, as below:
RiskAmountbySector =
SUM ( 'Risk'[ProfitlessRisk] )
/ CALCULATE ( SUM ( 'Risk'[ProfitlessRisk] ); ALL ( 'Risk'[SectorID] ) )
measure works like charm. However, I want to show the sectors those percentage is 2% and below as "Other" in bar graphic whenever i change the branch.
any help is appreciated.
any help?
Solved! Go to Solution.
Hi, @Anaxielia
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
Table:
You may create a calculated column as below.
New Category =
IF(
[Percentage]<=0.02,
"Other",
[Category]
)
Result:
Best Regards
Allan
If this post helps,then consider Accepting it as the solution to help other members find it faster.
Hi, @Anaxielia
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
Table:
You may create a calculated column as below.
New Category =
IF(
[Percentage]<=0.02,
"Other",
[Category]
)
Result:
Best Regards
Allan
If this post helps,then consider Accepting it as the solution to help other members find it faster.
Hi ,
I have a problem with that tutorial:
- I followed the steps however, when i tried to put into a measure, i cant select the column that would work as "used or other" info. I got "A circular dependency" error if i create as a new column. because the measure i want to rank, is using the same column (sector ID) and calculates the percentage of the risk of sector.
User | Count |
---|---|
120 | |
69 | |
69 | |
57 | |
50 |
User | Count |
---|---|
167 | |
82 | |
68 | |
65 | |
53 |