Data tables - need help

[rocky777]

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]

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]

I want to repeat this work 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]

Hi @rocky777,

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.

For your second question. It is able to achieve. You just need to create relationship between these filters. And what are the relationships?

Thanks,
Xi Jin.

[rocky777]

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”).

“Migration increase” = “arrived” – “left”

“Natural increase” = “born” – “dead”

I’d like to repeat this project http://aitoff.ru/migrationrbt (the 1-st widget).

Here is the data source: 4 the same tables 2015-2018 with different values.

Spoiler

I don't know how to build the relationships properly to achive the desired result like in the project i linked above.

[rocky777]

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.

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.

“Migration increase” = “arrived” – “left”

“Natural increase” = “born” – “dead”

Thank you for your patience!