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

No video

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

Рет қаралды 6,877

Күн бұрын

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 📧
info@havensconsulting.net
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodel #fieldparameters

Пікірлер: 15

@buchiihez7766 5 ай бұрын

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

@HavensConsulting 5 ай бұрын

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

@Guiburgueir4 5 ай бұрын

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 5 ай бұрын

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

@XoFoKleX 5 ай бұрын

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!

@kennethwaynescott8469 5 ай бұрын

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

@AgulloBernat 5 ай бұрын

Audio and image are not quite in synch

@HavensConsulting 5 ай бұрын

Will take a look next time I record

@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

@marianacastellanosmontero8890 3 ай бұрын

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

@HavensConsulting 3 ай бұрын

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

@marianacastellanosmontero8890 3 ай бұрын

@@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?