Dynamic Column Headers (with Field Parameters) in Power BI!

Learn how to combine Field Parameters, relationships, and DAX to create dynamic "column" headers in Power BI. Tune in to learn more!

RELATED CONTENT 🔗

BECOME A CHANNEL MEMBER 🎉

CHECK OUT OUR MERCH STORE 👕

LET'S CONNECT! 🧑🏽‍🤝‍🧑🏽 🌟

HAVENS CONSULTING PAGES 📄

EMAIL US AT 📧

#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodel #fieldparameters

[Guiburgueir]

I've used this technique extensively for the creation of language user-selectable reports. I have some suggestions/notes:

◦ You can create the any column directly on the DAX formula of the parameter table just adding another value after the Order numbers.
◦ The sort order can repeat between "groups" that will never be displayed together.
◦ I really recommend to edit the values of the sort order to reduce future maintenance work, you can start on 100, 200, 300... so you will be able to add any new column and avoid the need of changing every order value existent, you will be able to just pick some number in-between for the new column.

[buchiihez]

I think this is awesome Reid....a little confusing but sure going through it again, it should sink in and adopt

[AgulloBernat]

Audio and image are not quite in synch

[FerozAhmad]

when you select a columns from a list of columns and selected columns gets displayed but when we select nothing all columns gets displayed but i want nothing should be in table visual. How to achieve it?

[marianacastellanosmontero]

What did you do to create the Window Key column in the field parameter table?