Limit Bar Graph Values

[tonatiuhalan]

While making a report, depending on the selection of certain slicers, the data displayed in the bar graph for some categories can be much bigger than others (as shown below)

This makes comparing the data a little bit difficult. I was wondering if there's a way to 'limit' (truncate) the values to display in the graph to a certain amount.

For the example above for it to show instead of 597% display the bar corresponding to a 100% height with a label '>100%' and maybe the tooltip does dispaly the real value.

In this example the percentage is calculated via a measure in DAX. I suppose there must be a way to modify the code in order to display what I want, but just can't find how exactly.

Thanks

[rsbin]

@tonatiuhalan ,

You can try something like this.  Create a new Measure using IF or SWITCH:

YourMeasure_Display = IF( [Your Measure] < 1,[Your Measure], 1 )

Then use this new Measure in your Visual.

In the Tooltip you can then use [Your Measure] to display the true or actual result.

Hope you are able to follow the logic behind this.

Regards,

[CoreyP · Accepted solution]

Sure, you could do that. You would need to update the DAX measure to something like below:

New Measure = 
VAR _actualvalue = [Current Measure]
VAR _result = IF( _actualvalue > 1 , 1 , _actualvalue )

RETURN
_result

Then set this as a Dynamic measure so you can use custom string formatting to format the data label / tooltip for "100% +" value