Avoid display empty column in pivot

Anything related to PowerPivot and DAX Formuale
Bernard Heymans
Posts: 34
Joined: Wed Feb 28, 2018 12:18 am

Avoid display empty column in pivot

Postby Bernard Heymans » Fri May 17, 2019 12:51 am


I face a problem of columns that should not be shown.

I analyse revenue over years.

for the past I only keep revenue.
but for current year I have Revenue, budget, revised budget.

As I want to calculate the ratio between revenue & budget I created such a measure. easy.

The problem is that there is no result revenue/budget for the past... & all columns are shown.
Can I avoid these EMPTY columns? ( RED in the attachment)


Empty column in pvt.xlsx
(150.34 KiB) Downloaded 35 times

Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 1 guest