How to filter data in a month by most sold product

[Anonymous]

Hi,

I am totally new to Power Bi and honestly, i am having hard time understanding how to filter data. I tried multiple things and nothing worked for me.

Basically, i want to filter data by month by most sold product.

For each shop i want to show the best selling item in that month.

For example (i want to show only the row with red squares for shop 1 in January).

Please help me.

[az38 · Accepted solution]

Hi @Anonymous 

create a column

Rank = RANKX(
FILTER(
'Table';
'Table'[Date] = EARLIER('Table'[Date])
);
'Table'[Sales]
)

then put this column into visual filter pane and filter by rank=1