Visual error when keep doing mouse clicks between Pie Chat and Stacked Bar Chart

[Anonymous]

I am getting this error very consistant.  Not matter what data.

This is the step to get the error.

1.  Put a pie chat (Axis = Neighborhood, Legend =Neighborhood, Value = Count Distinct ProjectID)

2.  Put a Stacked Bar Chat (Axis = Neighborhood, Legend =Neighborhood, Value = Count Distinct ProjectID_

3.  Keep do mouse click between these 2 visuals by highlight the chat.  after few click and getting ths error.

Feedback Type:
Frown (Error)

Timestamp:
2019-03-11T17:38:05.1611007Z

Local Time:
2019-03-11T10:38:05.1611007-07:00

Session ID:
XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXX

Release:
February, 2019

Product Version:
2.66.5376.2521 (19.02) (x64)

Error Message:
The DataSet 'DS0' contains a filter with duplicate columns and distinct values for the duplicate columns, which is not allowed.

OS Version:
Microsoft Windows NT 6.1.7601 Service Pack 1 (x64 en-US)

CLR Version:
4.6.1 or later [Release Number = 394271]

Peak Virtual Memory:
4.29 GB

Private Memory:
478 MB

Peak Working Set:
732 MB

IE Version:
11.0.9600.19236

User ID:
XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXX

Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Telemetry Enabled:
True

Model Default Mode:
Import

Snapshot Trace Logs:
C:\Users\XXX\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot579676636.zip

Performance Trace Logs:
C:\Users\XXX\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Enabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_variationUIChange

Disabled Preview Features:
MIntellisense
PBI_SpanishLinguisticsEnabled
PBI_PdfImport
PBI_ColumnProfiling
PBI_PythonSupportEnabled
PBI_showIncrementalRefreshPolicy
PBI_showManageAggregations
PBI_FuzzyMatching
PBI_EnableWebDiagramView
PBI_improvedFilterExperience
PBI_qnaLiveConnect
PBI_keyDrivers

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
USGovCloud

DPI Scale:
100%

Supported Services:
Power BI

Formulas:

section Section1;

shared Query1 = let
Source = Sql.Database("ServerName", "DBName", [Query="SELECT * FROM Project"])
in
Source;

[v-qiuyu-msft]

Hi @Anonymous ,

I tried to reproduce the issue on my side but unfortunately not.

Would you please record a video to show the step "Keep do mouse click between these 2 visuals by highlight the chat.  after few click and getting this error"?

Also would you please share the pbix file? 

If possible, you can upload them to your Onedrive and send the share link to me via private message. 

Best Regards,
Qiuyun Yu 

[Anonymous]

@v-qiuyu-msft 

I send you private message with files and video you needed.

[v-qiuyu-msft]

Hi @Anonymous, 

It's not idea to put the same column field to Axis and Legend buckets in the chart visual. I have updated your pbix file and this time the issue will not occur. I will send you updated pbix file via private message. 

Best Regards,
Qiuyun Yu 

[Anonymous]

That is not make sense.  

if it is the feature restriction, it should not allow user to put same item on both Axis and Legend.  Or show us a document from Microsoft about limitation for the visual.

Or An error occur at the beginning putting same column file to Axis and Legend.  Not about after many click.

In my chart I have the person name and count project.  I have no idea what else should I put for the Legend in the use case.

[v-qiuyu-msft]

Hi @Anonymous, 

Have you viewed the updated report I sent you via private message previously? 

In your scenario, you needn't to add the duplicate column field to Legend bucket. 

Best Regards,
Qiuyun Yu  

[_______________]

Hi @Anonymous,

I had a column placed in the filter and in the legend with the same result/issue. After I removed the column from the legend the issue is gone.

So many thanks for your solution!

Marc