Forum Discussion

tonatiuhalan's avatar
tonatiuhalan
Regular Visitor
2 years ago
Solved

Limit Bar Graph Values

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 comp...
Need Help
  • CoreyP's avatar
    CoreyP
    2 years ago

    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

rsbin's avatar
rsbin
Community Champion
2 years ago

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,