- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
allocating a location to each component of a table (over time)
I got a table with some components (columns) and their values change over time(-column). Now I am wondering if I can allocate a generall location to each component. My idea was to create a second table with the components (columns) and their generall location and then (somehow) merge both tables by query editor, so firstly I can depict the values over the course of time (first visualization) and secondly I can visualize the location of each component (map visualization). Both visualizations should then be connected.
Is that somehow possible to realize? Thank you for your help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @tilldunk,
Please share your sample table, so that we can see the data structure. Based on your description, you create a map visualization and another one, what visual did you use for another one? Please share more details, so that we can post detailed solution.
Best Regards,
Angelia
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
First of all, thanks for your quick reply.
I got two sample tables (1st table, 2nd table). I want to allocate a generall location to each of those three components (1. comp, 2. comp, 3. comp) so I can generate two visualizations (1st visualization: area chart with values over time; 2nd visualization: map, where you can find out the location of each component).
Is it possible to connect both tables so each component is related to a generall location? Thanks for your help
1st table: component values over time
2nd table: allocated locations
1st visualization: values over time (area chart)
2nd visualization: location of each component (map)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @tilldunk,
>>Is it possible to connect both tables so each component is related to a generall location?
If my understanding is right, you want to connect the two tables. When you select 1.comp in map, the first visualization just display the 1.comp values over time, the wo visualizations effect each other, right? If it is, it is impossible. Because we create relationship between two table based on rows of each table, we can not find a common rows from both table. In addition, you want the 1.comp, 2.comp, 3.comp values in component field to filter the 1.comp column, 2.comp column, 3.comp column in Table1, we have so such a feature, you can create an idea here, you can also review this and vote it.
Best Regards,
Angelia
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Would need to see some data on how it is setup.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I got a table with some components (columns) and their values over time(-column). Now I am wondering how I can match them with a location. My idea was creating a new table with all components allocated to their location and subsequently (somehow) merge both tables with the query editor.
My goal is to visualize the component values over the course of time (first visualization) and additionally depict the location of each component an a map (second visualization) while both visualizations are connected.
Thank you

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-15-2024 01:24 AM | |||
03-15-2024 09:09 AM | |||
06-03-2024 06:45 AM | |||
05-06-2024 02:35 AM | |||
12-06-2023 07:08 AM |
User | Count |
---|---|
140 | |
110 | |
81 | |
61 | |
46 |