cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Syndicate_Admin
Administrator
Administrator

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

Gabs92_1-1656541785027.png

5 REPLIES 5
MFelix
Super User
Super User

Hi @Gabs92 

 

What do you mean by having the charts change in order?


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Gabs92
Regular Visitor

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


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Gabs92
Regular Visitor

Hola, ya lo intenté pero me da un gráfico por columna y yo necesito el gráfico por todas las columnas. Se puede hacer esto?

 

Gracias

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.

Gabs92_0-1656680977237.pngGabs92_1-1656681182718.png

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

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors