Forum Discussion
Zebra BI Bar charts | Help with Setting Consistent Y-Axis Range
Hello Power BI Community,
I’m currently working on a Power BI report with two Zebra BI visuals, both on the same page. I’ve attached a screenshot of the report to help illustrate the issue.
Problem Description:
In the visuals, the Y-axis is auto-scaled, which is causing inconsistencies in the comparison of values. Here are the values for each of the categories:
Type A:
- Old: 12.4
- New: 13.0
Type B:
- Old: 37.3
- New: 39.1
The issue is that the charts auto-scale, making it difficult for users to accurately compare the "Old" and "New" values across the categories. I would like to set the maximum Y-axis value to 39.1 (the maximum value from the data), or ideally 43.0 (110% of the max value) to provide extra space and make the comparison more obvious.
Desired Outcome:
- I want to ensure that both charts have the same Y-axis scale.
- The Y-axis should reflect the actual maximum value of the data (or a slightly higher value) so that the bars are not distorted by auto-scaling.
- The goal is to provide a clearer visual difference between the "Old" and "New" values.
Request:
- Can this be done within the Zebra BI visuals? If yes, could someone kindly share how to adjust the Y-axis range in Zebra BI?
- Alternatively, if a native Power BI bar chart might be a better solution, could you provide a step-by-step guide for setting the Y-axis to a fixed range in Power BI?
Thank you in advance for your help!
PS: This is my first post 🙂 Zebra BI on Power BI
Hi AKretschmer ,
Thank you for reaching out to Microsoft Fabric Community.
To show the percentage deviation for both bar charts on the same report page, a Pro license is not required. Your measure might not be calculating the standard deviation correctly. Attached is the pbix file with sample data. Let us know if you have any further questions; we are happy to address them.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you!!
6 Replies
- AnonymousNot applicable
Hi AKretschmer ,
Regarding the auto-scaling issue you mentioned, we recommend that you try merging the two visuals into one, which provides a more intuitive comparison.
Best Regards,
ZhuIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- AKretschmerFrequent Visitor
Hi Anonymous,
Thank you for your answer. This makes absolutely sense.
How is it possible to show the relative percentage deviation for both bar charts?
I can only show one in the free version. Do I have to use the pro version for this?
BR Andreas- v-sathmakuri
Community Support
Hi AKretschmer ,
Thank you for reaching out to Microsoft Fabric Community.
To show the percentage deviation for both bar charts on the same report page, a Pro license is not required. Your measure might not be calculating the standard deviation correctly. Attached is the pbix file with sample data. Let us know if you have any further questions; we are happy to address them.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you!!
- v-sathmakuri
Community Support
Hi AKretschmer ,
May I ask if the provided solution helped in resolving the issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you!!
- v-sathmakuri
Community Support
Hi AKretschmer ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you!!
- v-sathmakuri
Community Support
Hi AKretschmer ,
I hope the information provided is helpful. Feel free to reach out if you have any further questions or would like to discuss this in more detail. If responses provided answers your question, please accept it as a solution so other community members with similar problems can find a solution faster.
Thank you!!