6 Replies Latest reply on Jul 19, 2018 6:38 AM by Bryce Larsen

# Fixing the length of bars in viz after it reaches a certain number

Hello All,

I am working with sensitive data and wish to fix the length of the bar in order to fake the axis. For example: if i reach a count 5 for a field, i would like to show the length of the bar representing a number = 4 as 5*, putting a disclaimer that due to sensitive information, we do not give exact numbers when less than 5.

I have created a calculated field which does not show the number but "*" when number< 5, but the problem is axis, a person can still see the length of bar and compare it to the axis to get the exact number. This is the problem i am trying to avoid by faking the length of bar to 5 for all numbers<5 but with an * sign.

Is it at all possible to achieve this? Please let me know if we can make it work.

Regards

• ###### 1. Re: Fixing the length of bars in viz after it reaches a certain number

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.

• ###### 2. Re: Fixing the length of bars in viz after it reaches a certain number

Hi

I am not sure about a direction solution for this issue. But is it ok if we mask the axis with another dummy axis?

Regards

Vishnu

• ###### 3. Re: Fixing the length of bars in viz after it reaches a certain number

Hi Puneet

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.

Regards

Vishnu

• ###### 4. Re: Fixing the length of bars in viz after it reaches a certain number

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!

Best,

Bryce

1 of 1 people found this helpful
• ###### 5. Re: Fixing the length of bars in viz after it reaches a certain number

Hi Bryce,

Thank you for your time and effort, it is truly appreciated. It worked the way you mentioned.

Cheers,

Puneet