Open Side Menu
Skip to contentBrand Logo
Forums
Inspiration
Ideas
Communities
Blogs
Learning
Support
RegisterSign In
  1. Microsoft Fabric Community
  2. Power BI forums
  3. Galleries
  4. R Script Showcase
Sharon's avatar
Sharon
Microsoft Employee
10 years ago

Data Smoothing with Splines

Description Smoothing helps you to better visualize and understand noisy data   Prerequisites (The sample .pbix files will not work without these prerequites completed) 1. Install R En...
Smoothing Splines Showcase.pbix561 KB
ScriptInstallPackagesWithWorkaroundsSpline.R1 KB
General R Visualizations
andymc123's avatar
andymc123
Advocate III
6 years ago

I have R installed, but I am a rookie.  I was able to install all of the necessary packages so that the sample .pbix file provided here loads and works just fine for me.  When I try to add the spline visual to my own .pbix file it doesn't want to accept measures in the X and Y axis.  Message on the visual simply states "Need numeric X and Y variables".  They are numeric, the Data Type is "Decimal Number", but formatted as "Percentage".  Why wouldn't I be able to use measures?  The data I have works just fine with the built in Power BI "scatter chart".  What I really want is the line so that I can keep a National Average line on the visual and cross-highlight by districts to see the distance from a National Average.

 

Very cool visual, I hope that I can get it working.

  • © 2026 Microsoft
  • Manage cookies
  • Privacy & cookies
  • Terms of use
  • Trademarks
Your Privacy Choices Consumer Health Privacy