Forum Discussion
Correlation Plot visual - issue
Hi team,
I’m trying to visualize in a Correlation plot visual, the correlation between the Values of two different tasks. Here is my data:
Date | DateKey | Task | Value |
01.01.2022 | 20220101 | AA1 | 35 |
02.01.2022 | 20220102 | AA1 | 40 |
03.01.2022 | 20220103 | AA1 | 50 |
04.01.2022 | 20220104 | AA1 | 100 |
05.01.2022 | 20220105 | AA1 | 20 |
06.01.2022 | 20220106 | AA1 | 30 |
07.01.2022 | 20220107 | AA1 | 90 |
08.01.2022 | 20220108 | AA1 | 17 |
09.01.2022 | 20220109 | AA1 | 19 |
10.01.2022 | 20220110 | AA1 | 21 |
01.01.2022 | 20220101 | BB2 | 60 |
02.01.2022 | 20220102 | BB2 | 54 |
03.01.2022 | 20220103 | BB2 | 23 |
04.01.2022 | 20220104 | BB2 | 90 |
05.01.2022 | 20220105 | BB2 | 75 |
06.01.2022 | 20220106 | BB2 | 12 |
07.01.2022 | 20220107 | BB2 | 36 |
08.01.2022 | 20220108 | BB2 | 78 |
09.01.2022 | 20220109 | BB2 | 77 |
10.01.2022 | 20220110 | BB2 | 29 |
01.01.2022 | 20220101 | CC3 | 130 |
02.01.2022 | 20220102 | CC3 | 140 |
03.01.2022 | 20220103 | CC3 | 36 |
04.01.2022 | 20220104 | CC3 | 76 |
05.01.2022 | 20220105 | CC3 | 44 |
06.01.2022 | 20220106 | CC3 | 35 |
07.01.2022 | 20220107 | CC3 | 29 |
08.01.2022 | 20220108 | CC3 | 57 |
09.01.2022 | 20220109 | CC3 | 28 |
10.01.2022 | 20220110 | CC3 | 95 |
I have installed R and the ‘corrplot’ package, but when I try to put “Task” field and Value, no data populates in the visual. The only way to see data in the visual is to put two value fields, but no task (text).
The end result I’m looking for is this:
*The first left bubble should be the correlation between sum of the values of AA1 and sum of the values of AA1. The second bubble, row one, is the correlation between sum of the values of of BB2 and sum of the values of AA1.
Do you have an idea is it possible to present my data in this look with a correlation plot visual or what transformation should I make?
Thank you.
Hi, Anonymous
A correlation plot can display the correlation among different measures, and optionally you can create some clusters by correlation coefficient. You need to convert the value you want to display into a MEASURE display.
Here is the related document, hope it can help you.
https://arpitatechcorner.com/2021/07/26/correlation-plot-in-power-bi/
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
- v-zhangtiCommunity Support
Hi, Anonymous
A correlation plot can display the correlation among different measures, and optionally you can create some clusters by correlation coefficient. You need to convert the value you want to display into a MEASURE display.
Here is the related document, hope it can help you.
https://arpitatechcorner.com/2021/07/26/correlation-plot-in-power-bi/
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.