Forum Discussion

EpicTriffid's avatar
EpicTriffid
Icon for Helper IV rankHelper IV
6 years ago

Last three from a specific year

Hi all,   I have a column that identifies whether a year is our most recent year for a specific KPI. Some of our KPIs have been released this year, but some others havent been updated since 2017. S...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
EpicTriffid's avatar
EpicTriffid
Icon for Helper IV rankHelper IV
6 years ago

Hi Anonymous 

 

Thanks for the reply. I'm not entirely sure how to apply the blog post to my report. It seems to be more adding up totals rathet than filtering years shown. 

 

Thee the only functions in the data are switches to change the format.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI EpicTriffid ,

AFAIK, power bi visual will auto-hide blank/empty records, but it not work on your side. Can you please share some dummy data with same data structure for test? 

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng