Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

multiple geographies on the same state

we have data where we have multiple geographies within the same state. however, when the map is drawn, it is coloring and displaying only the first geography

 

is there anyway around this to have it show the states as multiple colors

Need Help

2 Replies

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    8 years ago

    Anonymous

     

    In this scenario, since you have multiple entries for same state, it must "aggregate" when you analyze data on state level. You should add a lower granularity column like city, then put city column into visual so that it can show corresponding color for each city. Otherwise, it will always show only 1 color for state.

     

    Regards,

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      we tried using zip code, but it crashes. the data is not large either.

       

      this is the error we get


      Error Message:
      An error occurred while rendering the report.

      Stack Trace:
      Microsoft.PowerBI.Client.Windows.JavaScriptException: An error occurred while rendering the report.
      TypeError: Cannot read property 'split' of undefined
          at Object.splitByWidth (ms-pbi://pbi.microsoft.com/minerva/scripts/visuals.js:2065:46)
          at TooltipContainer.updateTooltipTextLines (ms-pbi://pbi.microsoft.com/minerva/scripts/visuals.js:46032:66)
          at TooltipContainer.setTooltipData (ms-pbi://pbi.microsoft.com/minerva/scripts/visuals.js:46015:30)
          at TooltipContainer.move (ms-pbi://pbi.microsoft.com/minerva/scripts/visuals.js:45918:37)
          at VisualHostTooltipService.move (ms-pbi://pbi.microsoft.com/minerva/scripts/exploreui.js:21115:43)
          at VisualHostTooltipService.show (ms-pbi://pbi.microsoft.com/minerva/scripts/exploreui.js:21110:26)
          at TooltipServiceDelegate.powerbi.define.TooltipServiceDelegate.showTooltip (ms-pbi://pbi.microsoft.com/minerva/scripts/visuals.js:38355:47)
          at SVGPathElement.<anonymous> (ms-pbi://pbi.microsoft.com/minerva/scripts/visuals.js:38412:106)
          at SVGPathElement.__onmouseover.tooltip (ms-pbi://pbi.microsoft.com/minerva/scripts/powerbi.common.externals.js:8520:18)

      Invocation Stack Trace:
         at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
         at Microsoft.Mashup.Client.ClientShared.FeedbackErrorInfo..ctor(String message, Exception exception)
         at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWin32Window activeWindow, WindowsHost windowsHost, FeedbackPackageInfo feedbackPackageInfo, Exception e)
         at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.<>c__DisplayClass1.<HandleException>b__0()
         at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass3.<SendAndMarshalExceptions>b__0(Object null)
         at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
         at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
         at System.Delegate.DynamicInvokeImpl(Object[] args)
         at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
         at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
         at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
         at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
         at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
         at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
         at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
         at System.Windows.Forms.Control.WndProc(Message& m)
         at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
         at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
         at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
         at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
         at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
         at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
         at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
         at Microsoft.Mashup.Client.ClientShared.WindowManager.ShowDialog[T](T form, IWin32Window owner)
         at Microsoft.PowerBI.Client.Program.<>c__DisplayClassb.<Main>b__0()
         at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass7.<HandleExceptionsWithNestedTasks>b__6()
         at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
         at Microsoft.PowerBI.Client.Program.Main(String[] args)