How to filter columns based on measure

[Anonymous]

Hi!

I have challenge in a report I am working with. Here you see a matrix visual with date on Rows and FG (= Fish Group) on Columns and number of fish on Values. If I have a date filter adding more days to it, you see what happen including 5. Jan. But when we come to 6.Jan, fishes are moved to other fish groups (FG 2 and FG4). Now fish group FG1 and FG3 is empty. My question is I want columns which has no fish not to be shown in the report. It works as is until the 5. Jan. How can I implement this using DAX measure

This is the final view of the report on 6 Jan. (Why there is fish in Fish Group FG2 and FG4 before 6. jan is because it has fish group the fish group FG1 and FG3 that now is empty). But that is not important now. I just want to hide columns that has no fish on the latest date in the date filter.

You can of course you other examples but I think I have described what feature I am looking for

Regards Geir

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

I think you want some dynamic columns in the visual. You can refer to this case. Download the sample file of this case and modify it to get the result you want.
https://community.powerbi.com/t5/Desktop/Dynamic-column-selection-for-matrix-visual/m-p/687993