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

       

      • 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