Thanks for the reply. If I change it from a Dimension to a Measure, I can't use histograms, as far as I can tell. This representation is standardized in our field (usually done in Excel), so needs to stay as is.
1 of 1 people found this helpful
Here is a solution, although it is admittedly convoluted. It uses Quantity as the dimension and Sales as the measure from the Superstore sample data set.
1. Make a calculated field that is :
IF RIGHT(STR(ROUND(ATTR([Quantity])/5, 1)), 1)="0"
2. Drag Quantity to Columns, then drag the calculated field to Columns.
3. Drag Sales to Rows.
4. Drag the calculated field to color and edit the colors accordingly.
5. Right-click the Quantity pill and deselect Show Header.
6. Right-click the calculated field name above the graph and select Hide field names for columns
7. Right-click the graph itself and select Format. Go to the Borders section of the format menu and drag the Column Divider Level slider at the bottom all the way to the left.
How does this look?
Benjamin Greene, that's PERFECT. Thanks so much. I never in a million years would have come up with this workaround. I did have to transform my column values back to numeric, but there were no problems. Here's how it looks now - I dropped the different colored bars because that wasn't necessary once we had the fix.
I'm glad to help!