Hide / Show table columns based on user input

[Anonymous]

Hello,

Apologies if this is obvious, I'm new to Power BI but gradually learning!

After a lot of trawling the forums, I don't think this is possible but wanted to ask the question in case anyone knows of a solution or alternative.

I have a table with a lot of columns, based on Year and Month data. For example, it shows several columns per month, repeatedly displaying for 12 months of the current year, past year and future year, therefore 36 columns.

I would like the user to be able to select which Year and Month they want to view and consequently display the relavant columns and hide the ones not required.

Is this possible please?

In the above example, I would like to keep all left side columns up to and including "Core/ New", but then the "Budget", "Forecaset", "FTE%", "Variance", "Actual" and "Variance Y-1" columns are only shown for the month selected by the user. Therefore, if the user only wanted to see October columns, all September columns would be hidden.  

Any advice would be really helpful, many thanks.

[Anonymous]

Thanks Christine. I managed to get this working but unfortunately it doesn't resolve my issue fully as it will position all the e.g. Budget columns together, then the Forecast columns together, rather than keeping the correct layout of Budget, Forecast % etc. It also removes the conditional formatting for each column when it's hidden/ shown.

I think I may be asking too much?!

Great tip though and I will use that in future 🙂

[christinepayton]

The conditional formatting should stick when things are added/removed using the field paramter slicer. The way the columns are grouped depends on how you organize your matrix. If you can get text labels next to the values in your data tables that assigns them as "budget" or "forecast" in the rows, then drop that into the column first, it should group those together (you could put month under that). 

[christinepayton]

It sounds like field parameters would fit your requirements - I did a video on how to use them to make dynamic tables here if that's helpful: https://youtu.be/tb3eDmA7CqE?si=0OpakE3S6485bbrO