The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 :')
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.
User | Count |
---|---|
11 | |
8 | |
6 | |
6 | |
6 |
User | Count |
---|---|
23 | |
14 | |
13 | |
10 | |
8 |