Year filter

[Anonymous]

Hi all,i am new to powerbi and starting out on some simple data of sale for 3 company (Jan-Dec) over 3 years

How can I get the filter for the year based on current data?

Any hints or advice is appreciate 

[Anonymous · Accepted solution]

HI @Anonymous ,

You can do unpivot columns on your month fields on query editor side, then you can use unpivoted month attribute field as axis, company and legend, value field as value to create chart.
Unpivot columns (Power Query)

>>How can I get the filter for the year based on current data?

I think you can write a measure to use current row content to compare with today function, then apply it on visual level filter to filter records.

Regards,

Xiaoxin Sheng