Forum Discussion
Year filter
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 :smileyhappy:
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
1 Reply
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