How to filter between data

[sbajc101]

Hi. Im new to power BI, so sorry if the question is strange. 

I would like to filter between different data, shown in picture. Every ATT_RATE_... is for different month. And i would like to used in somekind of filter in one sheet in same dashboard. Or is it possible to set which data are shown in different filters ?

Thenks

Br

Simon

[moizsherwani · Accepted solution]

@sbajc101 

1) If every ATT_RATE is for a different month you are better of combining these in the Query Editor (using Append Queries). I am assuming there is some field in every ATT_RATE table which will let you know which month it is. If there is not such a field you can add a custom column to each query (in the query editor before appending) to identify which month of data the dataset belongs to

2) Once combined you can then use that month as a slicer on the page to filter the data 

Let me know if the above helps

[sbajc101]

Hi @moizsherwani . Yes, i needed to add month to each "att rate", in query editor, and it works.

Thanks.

Br

Simon