Passing data from a table or array

[Syndicate_Admin]

I have a couple of tables and matrices with data such as transport, agriculture, etc., and I need to graph the data in that row on other sheets, but only those of one of those data. I mean, if I click on the word Agricola, I need that value to pass to the other sheet to graph the values of Agricola.

[AlexisOlson · Accepted solution]

I'd recommend setting up a drill-through to another page of your report.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough

[HenriqueReis]

Hi,

It's a pleasure to help you!

You have two options:

1- Go to filters and select just agricola in the corresponding space

2- Create a filter and put the column "segmento" there and select "Agricola"

Abraços do Brasil!