Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hide / Show table columns based on user input

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 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
christinepayton
Icon for Most Valuable Professional rankMost Valuable Professional
2 years ago

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).