Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Etai-Fiedelman
Frequent Visitor

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)

EtaiFiedelman_0-1678951280348.png

Thanks!

Etai

1 ACCEPTED SOLUTION
Etai-Fiedelman
Frequent Visitor

2 REPLIES 2
Etai-Fiedelman
Frequent Visitor

Thanks !

amitchandak
Super User
Super User

@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...

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.