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.
Tengo datos que se ve simplificado se ve algo como esto
PersonID | año | Informe | Puntuación | Nivel |
123 | 20192020 | 1M | 65 | L2 |
134 | 20192020 | 1M | 55 | L1 |
123 | 20192020 | 1M | 67 | L2 |
145 | 20192020 | 1M | 95 | L4 |
123 | 20202021 | 1M | 75 | L3 |
134 | 20202021 | 1M | 55 | L1 |
134 | 20202021 | 1M | 45 | R |
145 | 20202021 | 1M | 78 | L3 |
Me gustaría producir un sankey Chart que se parece a arriba.
Lo mejor que puedo hacer es algo como esto:
He probado cada combinación de fuente, destino, etiqueta, etc. sin éxito.
A continuación, intenté crear medidas para poder filtrar el año y usar una medida para el destino y otra para las etiquetas de destino.
Y
Puedo tirar de estas medidas en una tabla y usarlas, pero no se arrastrarán a ninguno de los campos de Sankey.
Obviamente me estoy perdiendo algo. Me gustaría hacer esto en DAX sin ir a tablas de datos.
¿Pensamientos sobre cómo proceder? ¿Curioso?
así que
Solved! Go to Solution.
@SO ¿Cuál es el contexto de estos datos? ¿Qué es lo que quieres comunicar?
No entiendo completamente, pero he intentado pivotar los datos para que tenga una columna para el origen y una columna para el destino, simplemente no estoy seguro de qué usar para los valores en estas columnas (Usé Level y establecido para no agregar), pero no todas las personas ID tienen datos para ambos años...
Vea el archivo adjunto debajo de la firma.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Thanks very much Allison.
Each person has 6 scores for each reporting period and there are 6 reporting periods a year and there are 100K entrys per report. Pivoting the table is not an option for me so I was trying to find a way to use a measure to sort this out. We also use AnalysisServices.
You asked a great question, what am I trying to show? I'm trying to find people that have moved from one level to another over time. It appears that most remain at the same level, but some move up, and others down. I'd really like to have the pattern continue over several reports or years, but one step at a time. :-).
Thanks for attempt and much appreciated. I was able to generate my 'ideal' image by creating a small data set and doing what you did. Very intensive to do for each reporting period. Any more thoughts or ideas? I've watched many videos and read many forums and tried many measure codes, but I cannot get it to work for me.
@SO ¿Cuál es el contexto de estos datos? ¿Qué es lo que quieres comunicar?
No entiendo completamente, pero he intentado pivotar los datos para que tenga una columna para el origen y una columna para el destino, simplemente no estoy seguro de qué usar para los valores en estas columnas (Usé Level y establecido para no agregar), pero no todas las personas ID tienen datos para ambos años...
Vea el archivo adjunto debajo de la firma.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Thanks very much Allison.
Each person has 6 scores for each reporting period and there are 6 reporting periods a year and there are 100K entrys per report. Pivoting the table is not an option for me so I was trying to find a way to use a measure to sort this out. We also use AnalysisServices.
You asked a great question, what am I trying to show? I'm trying to find people that have moved from one level to another over time. It appears that most remain at the same level, but some move up, and others down. I'd really like to have the pattern continue over several reports or years, but one step at a time. :-).
Thanks for attempt and much appreciated. I was able to generate my 'ideal' image by creating a small data set and doing what you did. Very intensive to do for each reporting period. Any more thoughts or ideas? I've watched many videos and read many forums and tried many measure codes, but I cannot get it to work for me.
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 |
---|---|
2 | |
2 | |
2 | |
2 | |
1 |