multiple geographies on the same state

[Anonymous]

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

[v-sihou-msft]

@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]

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)