Data tables - need help

Question

Hello guys! I wanna build smth. like this (screenshot) but I can’t get the way to build my general tables. What columns do I need to create in my excel file?

And 1 more thing. Is it possible when I press “All”(1) there are 4 filters (2 and 3), when I press “Migration increase” or ”Natural increase” there are only 2 filters (2 or 3 depend on the pressed button)?

greg_deckler · Answer

Not exactly sure what you are going for here. Do you not have any source data? What does it look like? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

rocky777 · Answer

I want to repeat this work&nbsp;http://aitoff.ru/migrationrbt (1-st widget) but i'm not sure what columns do i need to create in my microsoft excel file.

v-xjiin-msft · Answer

Hi&nbsp;rocky777,&nbsp;Not quite understand about what you want. What is smth? Please share us more information about your requirement. If you want to display a picture, you just need this picture URL. And set its Data Category to Image URL in Power BI.&nbsp;For your second question. It is able to achieve. You just need to create relationship between these filters. And what are the relationships?&nbsp;Thanks,Xi Jin.

rocky777 · Answer

That picture is the example I want my project to look like. I need to build a comparison table (Area / Years). Values depend on the pressed filter (“Migration increase”, “Natural increase”, “arrived”, “left”, “born”, “dead”).&nbsp;“Migration increase” = “arrived” – “left”“Natural increase” = “born” – “dead”&nbsp;I’d like to repeat this project http://aitoff.ru/migrationrbt (the 1-st widget).&nbsp;Here is the data source: 4 the same tables 2015-2018 with different values.Spoiler (Highlight to read)I don't know how to build the relationships properly to achive the desired result like in the project i linked above.

rocky777 · Answer

So here is the final table and the the screenshot with the relationships. Now i i'd like to add slicers (“Migration increase”, “Natural increase”, “arrived”, “left”, “born”, “dead”). The problem is that i don't understand what relationships i need to add to make those slicers.&nbsp;One more time: I want slicers to look like when u press “Migration increase” there are 2 more (“arrived” and “left”), when you press “Natural increase” there are other 2 (“born” and “dead”), and both together.&nbsp;“Migration increase” = “arrived” – “left”“Natural increase” = “born” – “dead”&nbsp;Thank you for your patience!&nbsp;

Forum Discussion

Data tables - need help

5 Replies

Related content

Upsert data to Lakehouse Table using copy data

Data preview Table vs Shortcut

Process data table to obtain subtotal table

Table visual with data from Data tab + measures

Fabric & Azure Data User Group Program Requirements & Benefits