How to remove columns when measure returns BLANK ? Old school financial report / table

[Bokazoit]

I am trying to build this old school finance report that show actual for the years 2022, 2023 and 2024 and then Estimate (budget) for 2024 and 2025

Since there is no data for the Estimate measure in 2022 and 2023 the columns are empty.

Is there a way to remove those columns (marked with red color)?

This is the table setup:

[Bibiano_Geraldo]

Hi @Bokazoit ,

Unfortunately, Power Bi does not support hidding a specif column or delete like in Excel, what you can do is resizing the column width till this column "hide" from the view. this is not the perfect way, but it can help when the auto size of column was disabled.

[danextian · Accepted solution]

Hi @Bokazoit 

Power BI does not natively provide an option to hide a measure if a specific slice, for example year =2022 in your case, returns blank for all rows.  The measure needs to become sort of a column by materializing it using a disconnected table.

Note: in the example above, I added a condition so Transactions show only if the year is 2024.

Please see the attached sample pbix.