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
fathomson's avatar
fathomson
Advocate II
9 years ago

Schedule view

  Description A relatively simple visualization to show start-stop of events at locations. Can be roomscheduling but also a production process with specific states at a given time. Although i...
schedules_in_powerbi_with_r.pbix381 KB
General R Visualizations
boefraty's avatar
boefraty
Microsoft Employee
8 years ago

Hi C_Houghton, 

 

You certainly can use ggplot functionality to get the required feature. 

BTW,  fathomson implmented R Custom Visual on the basis of this show case. 

It is still available here. 

 

As a quick and dirty "hack" to your problem you may try to add two zero-length resources at the beginning and the end of the day. 

 

 

C_Houghton's avatar
C_Houghton
Frequent Visitor
8 years ago

Thanks for your reply! That would be absolutely perfect, but i'm getting errors:

 

Feedback Type:
Frown (Error)

Timestamp:
2017-10-23T07:56:28.6198256Z

Local Time:
2017-10-23T08:56:28.6198256+01:00

Product Version:
2.47.4766.801 (PBIDesktop) (x64)

Release:
June 2017

IE Version:
11.608.15063.0

OS Version:
Microsoft Windows NT 10.0.15063.0 (x64 en-GB)

CLR Version:
4.6.2. or later [Release Number = 460798]

Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Peak Working Set:
386 MB

Private Memory:
271 MB

Peak Virtual Memory:
33.8 GB

Error Message:
R script error.
Loading required package: ggplot2
Loading required package: grid
Loading required package: gridExtra
Warning message:
package 'gridExtra' was built under R version 3.4.2
Loading required package: wesanderson
Warning message:
package 'wesanderson' was built under R version 3.4.2
Loading required package: RColorBrewer
Loading required package: dplyr
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'dplyr'
2: In libraryRequireInstall("dplyr") :
*** The package: 'dplyr' was not installed ***
Error in `levels<-`(`*tmp*`, value = if (nl == nL) as.character(labels) else paste0(labels, :
factor level [2] is duplicated
Calls: sortDataset -> factor
Execution halted


User ID:
db15c5fa-a129-4ae0-ba08-f5149b97bbcb

Session ID:
89517680-55f3-4784-b47f-0655edbd950b

Telemetry Enabled:
True

Model Default Mode:
Import

Snapshot Trace Logs:
C:\Users\ch1\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot293130851.zip

Performance Trace Logs:
C:\Users\ch1\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Enabled Preview Features:
PBI_Snowflake
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
PBI_allowBiDiCrossFilterInDirectQuery
PBI_pivotTableVisualEnabled
PBI_numericSlicerEnabled
PBI_daxTemplatesEnabled
PBI_relativeDateSlicer
CustomConnectors

Disabled Preview Features:
PBI_SpanishLinguisticsEnabled
PBI_PbiServiceLiveConnect

Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted

Cloud:
GlobalCloud

Time:
Mon Oct 23 2017 08:55:49 GMT+0100 (GMT Summer Time)

Client Error Code:
ServiceErrorToClientError

Error Details:
R script error.
Loading required package: ggplot2
Loading required package: grid
Loading required package: gridExtra
Warning message:
package 'gridExtra' was built under R version 3.4.2
Loading required package: wesanderson
Warning message:
package 'wesanderson' was built under R version 3.4.2
Loading required package: RColorBrewer
Loading required package: dplyr
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'dplyr'
2: In libraryRequireInstall("dplyr") :
*** The package: 'dplyr' was not installed ***
Error in `levels<-`(`*tmp*`, value = if (nl == nL) as.character(labels) else paste0(labels, :
factor level [2] is duplicated
Calls: sortDataset -> factor
Execution halted


Stack Trace:
Microsoft.PowerBI.ExploreServiceCommon.ScriptHandlerException: R script error.
Loading required package: ggplot2
Loading required package: grid
Loading required package: gridExtra
Warning message:
package 'gridExtra' was built under R version 3.4.2
Loading required package: wesanderson
Warning message:
package 'wesanderson' was built under R version 3.4.2
Loading required package: RColorBrewer
Loading required package: dplyr
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'dplyr'
2: In libraryRequireInstall("dplyr") :
*** The package: 'dplyr' was not installed ***
Error in `levels<-`(`*tmp*`, value = if (nl == nL) as.character(labels) else paste0(labels, :
factor level [2] is duplicated
Calls: sortDataset -> factor
Execution halted

 

Any insights off the bat? Or I can follow it up with the creator.

 

Thanks again

  • boefraty's avatar
    boefraty
    Microsoft Employee
    8 years ago

    Hi C_Houghton, 

     

    *** The package: 'dplyr' was not installed *** 

     

    Try to install it manually from RStudio

     

    > install.packages("dplyr") 

     

    • C_Houghton's avatar
      C_Houghton
      Frequent Visitor
      8 years ago

      Hi there,

       

      I installed that package - looks slightly better:

       

      Error Details:

      R script error.

      Loading required package: ggplot2

      Loading required package: grid

      Loading required package: gridExtra

      Warning message:

      package 'gridExtra' was built under R version 3.4.2

      Loading required package: wesanderson

      Warning message:

      package 'wesanderson' was built under R version 3.4.2

      Loading required package: RColorBrewer

      Loading required package: dplyr

       

      Attaching package: 'dplyr'

       

      The following object is masked from 'package:gridExtra':

       

          combine

       

      The following objects are masked from 'package:stats':

       

          filter, lag

       

      The following objects are masked from 'package:base':

       

          intersect, setdiff, setequal, union

       

      Error in `levels<-`(`*tmp*`, value = if (nl == nL) as.character(labels) else paste0(labels,  :

        factor level [2] is duplicated

      Calls: sortDataset -> factor

      Execution halted 

      • boefraty's avatar
        boefraty
        Microsoft Employee
        8 years ago

        Hi, 

        Make sure Dates are not hierarchies and no summary applied on other fields. 

        You welcome to send me the PBIX and I'll have a look . 

        boefraty @  microsoft  .  com 

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