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 i...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft 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)