Forum Discussion
Dynamic y-axis bar chart - prevent data labels from overlapping
- 2 years ago
RaMiRo87 , Ideally it should adjust , if you are using field parameters to switch measures
else create min and max like
min = minx(Values([Legal Enity), [Your measure] )*.9
max = maxx(Values([Legal Enity), [Your measure] )* 1.1
and use them in Y-axis Min/Max values
- Anonymous2 years ago
Hi, RaMiRo87
You can define a measure of the maximum value of the Y-axis, which depends on the field or measure used by your Y-axis. I created a sample as follows:
At this point, 900 is inside the column, and here are the steps to adjust it:
Visual>>Y-axis>>Turn off Logarithmic scale
Create a measure based on the field or measure you use on the Y-axis. The purpose of the entire maximum value is to allow the maximum value to be displayed on the Y axis higher than your actual maximum value.
Max y-axis = [Sum of sales]*1.1Click Maximum fx
In your case, your DAX expression should look something like this:
MaxValue = CALCULATE ( MAX ( 'fcontrolling'[Incoming Orders] ), ALLSELECTED ( 'fcontrolling' ) ) * 1.1How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, RaMiRo87
You can define a measure of the maximum value of the Y-axis, which depends on the field or measure used by your Y-axis. I created a sample as follows:
At this point, 900 is inside the column, and here are the steps to adjust it:
Visual>>Y-axis>>Turn off Logarithmic scale
Create a measure based on the field or measure you use on the Y-axis. The purpose of the entire maximum value is to allow the maximum value to be displayed on the Y axis higher than your actual maximum value.
Max y-axis = [Sum of sales]*1.1
Click Maximum fx
In your case, your DAX expression should look something like this:
MaxValue =
CALCULATE (
MAX ( 'fcontrolling'[Incoming Orders] ),
ALLSELECTED ( 'fcontrolling' )
) * 1.1
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- RaMiRo872 years agoFrequent Visitor
Hi Anonymous,
thank you very very much for the detailled description!
Especially your measure was nice to compare it to my current solution. 🙂
Thanks a lot!