Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I created a Bar+Line graph with the bar on the primary axis and the line on the secondary axis.
I am displaying the actual metric on the primary y-axis and the forecasted metric on the secondary y-axis. How can I force the secondary axis to be synchronized with the primary?
My issue is that when I drill down into a dimension, the actual performance might show a value like 10, but then the forecasted line graph might be at 15 but it would display lower than the actual value. The cause of this is that the secondary y-axis is scaled differently so it throws out any intuition of actual vs forecast that you would get from glancing at the chart.
go to format option , under Y-Axis u could find "Show secondary axis" option . turn off that one it will help u
Hi, thanks but I want to have a secondary axis.
My primary axis already has three components of the metric (stacked bar chart) and then the secondary axis is a line graph showing the forecasted metric. The delta between the actual performance and forecasted performance should be apparent at a glance, but it isn't when the y-scales are different.
Set the minimum 0 and maximum range by fx (formula), count, sum or .. for both Y and secondary-Y axis to be the same.
This is u want it ? am i right dude .
let me if not .
Negative. I need the y-axis to be exactly synchronized.
Primary y-axis = stacked bar chart showing the components of a metric (the three components sum up into a total), measured in minutes
Secondary y-axis = line graph showing the estimated/forecasted/predicted total for the same metric, measured in minutes
So if the primary y-axis goes from 0 - 25 minutes, I need the secondary axis to be in sync and also show 0 - 25. If I drill down into a specific dimension and the primary axis now goes from 0 - 5 minutes, I need the secondary y-axis to also go from 0 - 5.
Hi ,
Now its possible in line and clustered column chart,In formatting pane <-- Y-axis <-- put a range i.e start and end value in primary Y-axis(Optional) <-- switch off the secondary axis,its done primary and secondary Y-axis has been synchronised...
Drop a comment if it works in your case...
Cheers..
cool dude i got it , got it .
for this my solution is obviously we cant do this.
we can set static start and end point for both ,but that make no sense that i know .
sorry dude , i cant help u . even power BI also can't help i think so :-(((((((((((((((
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
108 | |
108 | |
108 | |
90 | |
61 |
User | Count |
---|---|
171 | |
138 | |
132 | |
102 | |
86 |