Forum Discussion
Representing a single row in a visual
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
2 Replies
- amitchandak
Super User
Anonymous , 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-solution-8e3eccb41bda
