Forum Discussion
Relate graph to matrix
Hello, I have little to use power bi so I could not find a way to make the following relationship automatically:
I have a Matrix that changes according to a slicer, what I need is for the graphs on the right to change order as the matrix remains. Both visualizations represent a total according to the month.
My first option was to arrange the Harm index data in alphabetical order and thus put graph by graph in that order. The problem is that there are values that when selected have less Harm data and the graphs no longer match.
Thank you
5 Replies
Hello
Basically I have a matrix, the columns are the months per year and the rows are a list of indicators. I have a slicer for location.
On the right, there is a graph by indicator that represents the values of the table, only graphing with line the values of month by year.
My first attempt was to organize the table in alphabetical order of the Indicators and I put each graph where I filtered that showed the indicator.
The problem is that I do not always have the same number of indicators and the graphs do not reflect this change because they were left with the fixed filter. That is, if a location has all the indicators the graphs look good, if it has fewer indicators the graphs do not coincide because they were created considering the order of indicators in the table.
If I do it in excel I can relate each graph with each row, but I can't find how to do it in power bi
Las gráficas las filtré 1 por 1 asumiendo que el orden alfabético de los indicadores no cambia. Mi problema fue que para ciertas ubicaciones (filtros con slicer) no tienen todos los indicadores, la tabla se filtra y muestra solo los indicadores que tiene pero las gráficas se mantienen en el mismo orden que las hice.
Hi Gabs92 ,
Have you tried the sparklines?
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-sparklines-tables
