Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi all,
I have a stacked column chart that is shown in PBI Desktop. The y-axis starts at Auto and ends with a dynamic value that is a measure:
When I publish the report to PBI Service the visual is not shown:
Desktop (the number is a separate card visual)
Service:
When I edit the report in PBI Service and change the y-axis end from the measure to the maximum value 398441, the visual is visible, but when it is larger than 398441, it disappears:
Result:
Change end to 398442:
Result:
Does anybody have an idea if this is a bug and/or how it can be fixed?
The reason I need this is that I have multiple stacked column chart visuals and I'm using the max value of all those visuals as the end of the y-axis for all of them, so they can be compared in size. This means, however, that the y-axis end (maximum of all visuals) is higher than the shown value for all visuals but one (which is the maximum).
Solved! Go to Solution.
I figured it out: The start was set to 0 on all but one visual. I had to remove the 0, so that the default value "Auto" would appear again, and then I re-typed 0. No change in Power BI Desktop where it always worked, but after publishing it worked in Power BI service, too!
Were you able to fix this? If yes, how? I am facing a similar issue where stock power bi line chart just shows as blank in service. However, using a custom line chart visual works but there's a need to use the stock power bi line chart due to dynamic formatting.
Hello. I was researching a similar problem I was having. I noted that I inadvertantly had toggled the <Customer Label> option to 'On'. My bar chart had labels in my desktop, but nothing at all in the service view. When I toggled it to 'Off', it worked as expected.
Thank you @GSE for posting your solution! I had almost exactly the same problem - I have several standard line graph visuals on a page, where all except one were completely fine, but one was fine in desktop but blank in service. They were all set for the y-axis to start at 0. I deleted the 0 on the problem graph, re-typed it and re-published - the visual now works!
I figured it out: The start was set to 0 on all but one visual. I had to remove the 0, so that the default value "Auto" would appear again, and then I re-typed 0. No change in Power BI Desktop where it always worked, but after publishing it worked in Power BI service, too!
Hi @GSE ,
I did a test, created a stacked column visual. Then sent it to the service, even if the value of value exceeds 398441, everything seems to be displayed normally. Unable to reproduce your problem.
publish to service:
Try to recreate this visual in the latest version of powerbi desktop, and then publish it to the service again.
Let me know the test result immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-henryk-mstf ,
thanks for your message. Unfortunately, the problem persists. In order to reproduce it, you have to set the end to a number larger than the maximum value shown (so not a value that exceeds 398442 (not 1 at the end), but 403141). And during my test I realized the problem only occurs if a single column is shown. If multiple columns are shown and the end value exceeds the maximum value shown, there is no issue.
@lbendlin: unfortunately, it's not related. Just changed the zoom and the visual is unchanged.
@GSE Have you seen the note on support.powerbi.com?
Power BI customers using Edge or Chrome V93 web browsers with the default page scale set to 100% may experience UI behavior issues when interacting with common web page controls, such as dropdown slicers, date pickers, or line charts. As a workaround, users can use the zoom setting of anything other than 100% which forces the browser to behave normally. Engineers have identified root cause, and an estimated time to mitigate will be provided shortly.
Might be related?