Representing a single row in a visual

[Etai-Fiedelman]

Hi everyone.

I have a large data set which has many rows with an ID number and a value for year.

I want to create a line chart which shows the value for each year. This part is easy but I also want to link it to another visual so when I press the point in the other visual which has the same ID only the relevant line chart will appear.

For example, I have a map with many facilities. Each faciliy has and ID which is identical in another data set with the value over the year (emissions). When I press a certain facility on the map I wan only the emissions of that facility to appear.

Here is the data set for emissions. Just to note, transposing the data does not help since it limits the amount of data (only 500 coluns)

Thanks!

Etai

[Etai-Fiedelman · Accepted solution]

Thanks !

[amitchandak]

@Etai-Fiedelman , one way is to have common facility dimesnion

second is use treatas pass value to another table measure

https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/

or measure like

calculate(countrows(table1), filter(Table1, Table1[facility] in values(Table2[Facility]) ))

Power BI- Power Query: When I asked you to create common tables: https://youtu.be/PqfGW6pl1Sw

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-soluti...