I get around this by having an actual value in one calc, and a display value in another. I use the display value to control the size of the bars.
IF [Actual Value] < 5 then 5 else [Actual value] END
In my case I have done this to truncate the length of extreme bars, but in the tooltips I display the actual value, not the display value. In your case you'll probably want to display STR(actual value) as a label if the value is 5 or greater, and "5*" if less than 5.
I am not sure about a direction solution for this issue. But is it ok if we mask the axis with another dummy axis?
PFA workbook for the solution. Let me know whether this will work for you
Below are the steps
1. Calculate Sales for each Subcategory using Fixed LOD.
2. Create a calculated field "Masked Sales"
3. Create tooltip field to mask the Sales
4. Create second tooltip field to show the Sales value for the unmasked categories
Once done, we can place these fields accordingly on the sheet. Hope this works for you. Please let me know.
Please be kind to mark the question as answered if the solution works for you. It will be a great help for other community members.
Similar/identical approach to Joe. You just make two separate calculated fields: one for the bar length and one for the label. I've left the actual "score" in here for you to see:
So for projects C, D, and F they have scores less than 5, but bars are all put at a length of 5 and the label of the bar is "***". Twbx attached.
Hope this helps!
NewBarLength.twbx 6.4 KB
Thank you for your time and effort, it is truly appreciated. It worked the way you mentioned.
Glad to hear it! If you can, please mark as Helpful when you have a chance.