Was reading through my RSS feeds today and read this excelent post by Robert Bruckner which shows you how you can hide a static column and how you can make sure you get the result you want:
All about Power BI, Modelling, DAX and Microsoft BI
Was reading through my RSS feeds today and read this excelent post by Robert Bruckner which shows you how you can hide a static column and how you can make sure you get the result you want:
Hi Kasper,
Is it possible to hide empty columns in a PowerPivot table? I have columns in my table with the year-over-year change.Since the first year does not have a YoY change, I have an empty column. I would like to hide this. I can hide the column in Excel, but that is problematic if I change the number of years displayed. Is there an option to do this in PowerPivot?
Thanks,
SF