Specifying measures as a setting value for visuals - A serious limitation that PowerBI must overcome

[pmdci]

For several visuals in Power BI, we have the ability to specify some sort of fixed value as a setting/parameter to improve analysis. A few examples:

• Values of constant lines, min/max lines, average, median and percentile lines.
• Gauxe axis: Min, Max Target
• Conditional formatting of table cells: minimum, center, maximum values

The problem is that for those parameters we can only specify a fixed, constant value. For example. I reckon that all visual settings should allow us to specify a measure as an option where the option to specify a constant value is possible. For those familiar with SSRS, this would be anlalogous to the fx button.

I see this as a serious limitation of Power BI, and I already had to use a competitor product in one of our implementations because of it.

You can vote for this suggestion here.

Remember: Since MSFT only seems to evaluate suggestions on a quantitative approach, unless people vote for this -- it might not ever happen.

Regards,

P.

[v-haibl-msft]

@pmdci

In the August Update,  PBI has already added the ability to create multiple data bound reference lines on clustered column and bar charts, line charts, and scatter charts. These new reference lines are calculated based on the max, min, median, average, or different percentiles of a selected measure.

We can also use a measure for Min, Max and Target for Gauge.

We can also use Conditional Formatting for measure as below.

Best Regards,

Herbert

[Habib]

Microsoft has already started providing these options on various visuals and they are adding this to remaining ones.

In recent release, they have proivded option to add trend lines on line chart based on Mean/Median/Avg etc.

Still work needed on conditional formatting.