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 🔗
Field Parameters -- learn.microsof...
BECOME A CHANNEL MEMBER 🎉
-- / @havensconsulting
CHECK OUT OUR MERCH STORE 👕
-- havens-consult...
LET'S CONNECT! 🧑🏽‍🤝‍🧑🏽 🌟
-- / havensbi
-- / reidhavens
-- / havensconsulting
-- / havensconsulting
HAVENS CONSULTING PAGES 📄
Home Page - www.havensconsu...
Blog -- www.havensconsu...
Blog Files -- www.havensconsu...
Files & Templates -- www.havensconsu...
Consulting Services -- www.havensconsu...
Online Courses -- www.havenscons...
Contact & Support - www.havensconsu...
EMAIL US AT 📧
[e-mail]
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodel #fieldparameters

[@AgulloBernat]

Audio and image are not quite in synch

[@HavensConsulting]

Will take a look next time I record

[@Guiburgueir4]

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.

[@HavensConsulting]

Those are some great insights! Doing multi-language support this way is clever.

[@XoFoKleX]

Hi, the multi language report sounds very interseting. Can you give me a high level overview how you use this technique? I'm trying to dinamically change the language of multiple dimensions based on user's language selection. Reid's approach works fine in case of one dimension (e.g.: change column headers dynamically), but I fail to create the logic to apply it to multiple dims (e.g.: change the row "headers" at the same time). Thank you if you can give me a few hints!

[@K_dyub]

I use this for language translation as well. It works but gets a little hectic when there's 30 languages. Would be nice if they enabled using measures as the names. However, I know that with it being a calculated table, that's not really possible. I'm a dreamer...

[@FerozAhmad276]

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?

[@HavensConsulting]

If you clear the slicer all will be visible, but if you have select all on, check that, then uncheck everything, the table will start empty

[@buchiihez7766]

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

[@HavensConsulting]

It requires a few steps but solves a problem a few clients have for sure!

[@marianacastellanosmontero8890]

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

[@HavensConsulting]

I used a DAX calculated column for that :) Window Key = SWITCH( TRUE(), '.Parameter - Dynamic Columns'[Parameter - Dynamic Windows Order]

[@marianacastellanosmontero8890]

@@HavensConsulting Thank you so much! I'm trying to do something similar with a report I have, is there a reason why you used a different table for the window key, couldn't you just add directly the 1,2,3 of the month window size to the fields parameter table you already had?

[@inlets1]

What is that bottom circle visual?

[@HavensConsulting]

:) Chord Visual appsource.microsoft.com/en-us/product/power-bi-visuals/wa104380761?tab=overview