Avoid display empty column in pivot

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

Avoid display empty column in pivot

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

Hi

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)

Thanks

Bernard.
Attachments
Empty column in pvt.xlsx
(150.34 KiB) Downloaded 16 times

Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: Bing [Bot] and 2 guests