How to get data from a perticular table in power bi

[Sathvik123]

Hello All,

I have a report getting data from 2 tables .Sales north and sales south.

1)select date, country,sales from north table

2)select date, country,sales from southtable

Both have same columns so I appended them as single query.

Now my requirement is I need to show a user input value to my user which have 2 values North and South.

So when my user selects north  show north table sales data and user selects South it has to South table sales.

Could any one please help how to do this

[v-yiruan-msft · Accepted solution]

Hi @Sathvik123 ,

Before append sales south and sales north table, add a custom column "Type" (="South" , ="North") to each of these two tables as shown in the figure below.

After adding, then append these two tables.

Then create some measures to get the info base on your requirement... Please find the details in the attachment.

If the above one can't help you get the desired result, provide some sample data in sales north and sales south table(exclude sensitive data) and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

How to upload PBI in Community

Best Regards

[lbendlin]

1)select date, country,sales,"North" region from north table

2)select date, country,sales, "South" region from south table