Loading

How Not to Display Rank 0 on Bump Chart

게시 일자: Apr 30, 2025
과업

When creating a bump chart, is there a way to prevent rank 0 from being displayed on the Rows axis? If the start and end of the axis are fixed, the top and worst lines are half hidden.

 

단계

Below is an example of creating a bump chart using Sample - Superstore.


1. Add YEAR(Order Date) field to Columns.
2. Add SUM(Sales) field to Rows.
3. Add Sub-Category field to Color.
4. Right click SUM(Sales) field and select Add Table Calculation.
5. Set a Table Calculation as follows:
 User-added image
 
6. Drag SUM(Sales) field from Rows to Data pane and rename it as Rank.
7. Right click on Rank > Change data type > Number(decimal).
8. Right click on Rank axis and select Edit Axis.
9. Configure Axis as follows:
   User-added image


10. Optional, select "Reversed" on Scale to show like the initial screenshot.
 

Knowledge 기사 번호

001465358

첨부 파일

Bump Chart.twbx

1211 KB

 
로드 중
Salesforce Help | Article