Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I want to plot a PCA scatter plot with product data and a static confidence ellipse with static product training data (this data must not be affected by slicers). Then have a date slicer that I can filter the product data by date to see how many of my product points fall within the static ellipse and if I have any outliers.
Product Data (sample):
Date | PC1 | PC2 |
07-05-20 | 0.23 | 0.25 |
08-05-20 | 0.28 | 0.29 |
Training Data (sample)
PC1_Train | PC2_Train |
0.24 | 0.26 |
0.28 | 0.22 |
Is there any way to build that static ellipse from the training data table and without having to define any relationship? I thought of including the training columns in my Product Data column but then the date slicer affects the Training Data, effectively changing the ellipse everytime I slice making the comparisons difficult
Is there any workaround that I can explore or do I just have to get rid of the date slicer (which will be a major feature loss).
Extract of my python visual code:
plt.scatter(a, b) #Scatter plot with product data plt.plot(c * np.cos(t), d * np.sin(t) , color = 'black') #Plot Ellipse with training data #Where a and b are columns with Product PC1 and PC2 data which is expected to be sliced #C and D are linked to PC1 and PC2 Training data currently from a different table
WIll appreciate any help.
Hi @PBI-Beginner ,
Pls refer to :
Hi @v-kelly-msft ,
Thanks for your reply.
I tried creating an inactive relationship between the two tables as a workaround but the python visual refused to work, demanding for an active relationship.
In my case, I need a static confidence ellipse to be created from two columns on table 2, and that data (on table 2) must not be affected by any slicers or filters applied to data on table 1 (hence the inactive relationship).
Regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
90 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |