Velg en organisasjon
How Not to Display Rank 0 on Bump Chart
Publiseringsdato: Apr 30, 2025
Oppgave
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.
Trinn
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:
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:
10. Optional, select "Reversed" on Scale to show like the initial screenshot.
Knowledge-artikkelnummer
001465358
Hjalp denne artikkelen med å løse problemet ditt?
La oss få vite det slik at vi kan forbedre!
