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.
Hi,
I have a problem with the Correlation plot custom visual in Power BI, it displays the visual as it should but the numbers are all wrong. Even if I use a very simple Excel file with just 30 observations the numbers I get in Power BI differ completely from the ones I get in Excel. I tried using the corrplot packhae directly in R (the same component that the Power BI visual uses) and there it gives me the exact same numbers as in Excel, so the problem is not in the visual itself - but in how it uses the data in Power BI.
I have tried changing the datatype of the columns from decimal to whole number and using Don't summarize as the default aggregation to really make sure it uses the raw data - but I still get incorrect numbers.
Has anyone else experienced this, and solved it somehow?
Thanks!
Solved! Go to Solution.
Hi Fredrik,
Good news. The Product Team will improve this visual in the next version. They also provide a more beautiful workaround, using a textual index column instead of a numeric index column. Please refer to the snapshot below.
Best Regards,
Hi @Anonymous,
The root cause is that Power BI removes the duplicates. The visual just uses a small part of the whole dataset. So the workaround is adding an index for now. I have consulted the Product Team and will update here later.
Best Regards,
Ah, that makes sense - thanks a lot for your reply!
I'll use the workaround for now 🙂
Best regards,
Fredrik
Hi Fredrik,
Good news. The Product Team will improve this visual in the next version. They also provide a more beautiful workaround, using a textual index column instead of a numeric index column. Please refer to the snapshot below.
Best Regards,
Is it updated yet? I am facing the same problem. Is the index parameter added yet?
Thanks a lot for the quick feedback! It's so nice to work with a tool that just keeps on improving all the time - good work!
Regards
Fredrik
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |