Forum Discussion
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...
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
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