KPI or Trend line - how to show calculated constant on axis?

[AgencyPowerBi]

Hi,

I have a question regarding visualising averages on bubble chart.

Now I have placed my data on a chart, calculated some weighted averges and want to show them on a chart as X-axis and y-axis.

In  effect, these averages should divide my chart to four quardants.

Now this is not possible through trends (x-axis and y-axis constants do not allow measures for input), so is there a workaround?

Another, connected thing.. how can I make max axis values dependant on the data?

If the bubbles are of variable size, axii do not allow for whole bubble to be seen. The center of the bubble is max axis point and half of the bubble is non-visible.

Can the value of min/max axis value be a variable? Or lets just make it fit 🙂 ?

Thanks!

[AgencyPowerBi]

Hi,

I have a question regarding visualising averages on bubble chart.

Now I have placed my data on a chart, calculated some weighted averges and want to show them on a chart as X-axis and y-axis.

In  effect, these averages should divide my chart to four quardants.

Now this is not possible through trends (x-axis and y-axis constants do not allow measures for input), so is there a workaround?

Another, connected thing.. how can I make max axis values dependant on the data?

If the bubbles are of variable size, axii do not allow for whole bubble to be seen. The center of the bubble is max axis point and half of the bubble is non-visible.

Can the value of min/max axis value be a variable? Or lets just make it fit 🙂 ?

Thanks!

[v-xjiin-msft]

Hi @AgencyPowerBi,

=> Now this is not possible through trends (x-axis and y-axis constants do not allow measures for input).

Yes, as I know currently Power BI doesn't support this. And I'm afraid there's no workaround. However you can submit an Idea here to help improve Power BI.

=> Can the value of min/max axis value be a variable?

I'm not quite understand your requirement. Did you mean Max or Min line in Analytics pane?

Could you please share more detailed information about your requirement like some screenshots of your desired result if possible?

Thanks,
Xi Jin.

[AgencyPowerBi]

>> Can the value of min/max axis value be a variable?

No, I ment Start/end values. Because I get this cut-off look on my bubble chart. Which is not good, not good at all, I tell you! 🙂

I don't get why there is no buffer value for start/end, since there is often a bubble size to look for. This does not happen in Excel charts

[v-xjiin-msft · Accepted solution]

Hi @AgencyPowerBi,

Sorry for late.

In your scenario, you want to custom the start and end of x axis as passing them variables. Right?

However, currently it is not supported. The two properties can only use fixed numbers. And there already exists a feature request here, you can vote it up. 

Thanks,
Xi Jin.