C_Houghton's avatar
C_Houghton
Frequent Visitor
8 years ago

This is exactly what I'd like to use, but I want to define limits to ensure a whole day is shown, even if the schedule only has 1 item half an hour long. 

 

Do you have any ideas on dynamically changing the scale? I'm currently using it with a Calendar visual allowing you to select days, which means it could be any day, so it needs a limit for x hours in a variable date :/

 

Another possible option (not ideal at all) is to add a placeholder for every day that is 24 hours long!

  • 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")