Custom Measure for Bar Chart Upper/Lower Bound Error Bar Limits - New to DAX , pls help :)

[Anonymous]

Hi -- I ran an OLS regression w/ an 80/20 split in python and added a bar chart of the predictor coefficients to Power Bi. I'd like to add error bars using the SE or upper/lower limits from the regression summary - I am struggling miserably. 

This is data I pulled from the model summary and added as a new table to Power Bi

I've added the upper and lower bound variables as fields in the error bar section:

But the auto-sum of the fields ruins the whole approach 😞

Adding all the error bars to 1

I'm pretty new to DAX...I've been trying to play around calculating the measure for the upper/lower bounds with SWITCH(TRUE(), but I'm only slightly familiar with doing this for slicers and combining it with the SELECTEDVALUE() or CROSSFILTERRED() functions.

Any help would be a blessing! Thank you :')

[v-jianboli-msft]

Hi @Anonymous ,

Do you mean that the values shown for the upper and lower limits are incorrect? From the screenshot you provided, they appear to be in text format? Please try changing them to a numeric format and then use an aggregation such as MAX\MIN\SUM.

For more details, please refer to:

Work with aggregates (sum, average, and so on) in Power BI - Power BI | Microsoft Learn

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.