Make your Power BI Visual POP with this column header trick

[@Baldur1005]

Well I am still waiting for dynamic (programable) column headers and formatting

[@RamsesKZ]

Yeap. Especially, affected by slicers. That would be cool.

[@ajaaskelainen]

Same

[@marshallwaters6193]

Building on this, you can also use the Windows Emoji Picker (Windows key + Period key) to insert symbols into the display names of fields, which include arrows, and red/green/yellow dots🔴🟩 and squares, among other symbols. You can also insert characters from other fonts like the Symbol font. I use Word to find and insert a special character →, than copy and paste it into the field label in Power BI.

[@Daedana]

The tips on the very basic renaming of headers inside tables saved my day!

[@matthewthiele9646]

My databases usually have underscores. It previously took take me forever to make them more presentable. Here is a quick way of removing the underscore and making them proper case in Power Query. Go to the advanced editor and replace the last bit with: ,Proper = Table.TransformColumnNames(#"Source",Text.Proper), ReplaceUnderscore = Table.TransformColumnNames(#"Proper",each Text.Replace(_,"_"," ")) in ReplaceUnderscore *Make sure to replace #"Source" with the previous step.

[@ITyraxI]

Interesting, title made me expect a more "aesthetic" thing tho.

[@tomduffhues622]

Very interesting to get user to drill down! Especially when they are inexperienced with PowerBI. Thanks Adam!

[@amitkumargangwar8818]

To achieve this, you can just turn off the 'Stepped Layout' in Row Headers options for the matrix. It will start displaying columns names of all sub categories on expanding.

[@tiagomcdonald4867]

Never thought about that approach before, even though it's so simple! Thanks Adam!

[@vyju246]

How can we put column header common to 3 column measures in matrix? Please suggest if there is a solution

[@reality4460]

Hi Adam, could you please make a video on stacked and clustered combined charts in power bi. Power bi doesn't not support Stacked Clustered chart together.

[@Simon-vc1wk]

Is there anyway to do this dynamically?

[@osPA78]

So simple...yet...so damn awesome!

[@michellejamison6263]

This is a very helpful and useful suggestion. Thank you.

[@kojohyper8126]

Thanks for this

[@VladMZ]

Had no idea... Very useful!

[@jayeshsuthar9198]

Great tip. Please can you advise within your map visual how you managed to achieve the white background?

[@rerangelt]

Love the trick. Ey Adam, i miss the Monday roundup!

[@BigM241]

If you right click on the field, it does come up with the option 'Rename for this Visual'. Same as the double click to rename.

[@ladylynnet]

Good to know I'm not the only one doing this. Downside is when users export the data, that rename carries through so the Excel column isn't named accurately. Would be nice if the matrix visual did something like this automatically, or had a field in the formatting pane where you could edit what shows there (like titles) without impacting the data field names

[@JupiterRamirez]

Can the "Rename for this visual" modify dinamically? or use Dinamic Row Title Header? ( IF X=1 Then "One" Else "Other")

[@eriol33]

simple trick but very useful!

[@pallapothularajendra3196]

Is it possible to freeze the first two columns in power bi table visual?

[@wbird1385]

Cool! and I can’t believe I haven’t thought of this. Not perfect (like dynamic column headers) but still a cool trick.

[@oscous6790]

do you have video ways to add visitor counter into the report

[@satshisats]

"Q" If we have multiple product categories in the columns of the matrix say Product A, Product B and Product C. How do we change the order of columns and make it Product B, Product A and Product C?

[@arnohoedelmans]

Thanx Adam!

[@DebayanKar7]

Is there any way to rotate the header names vertically?

[@YaroslavShelest]

Thanks!

[@gulhermepereira249]

I thought it would change the name dynamically as the user drills down the hierarchy :(

[@haithamfathy2324]

thanks a lot it helped me

Nice workaround. But dynamic labeling would be better. What happens if you drill....

[@ashu60071]

can we freeze panes in columns in power bi like excel

[@mindortv8462]

respect for the Cyberman on the monitor behind you

[@venkateshthammisetty7845]

It's good, thanks.

[@carinalindebjerglarsen1542]

I'm missing the possibility to add additional information to each column in a matrix. Would be great if the description would show in the Matrix as a hover, and not only when you hover the measure.

[@fr1sket363]

so simple it's criminal haha, never thought of this.

[@Simon-vc1wk]

Nice tip

[@LeighRadmore]

Can you rename a measure/column name dynamically based on a slicer selection?

[@roxy4623]

Use selected value and do conditional formatting for title.

[@igorpoleshchuk735]

Alas, it’s not possible for a measure/column name except you use calculation groups.

[@magorzatatomkowicz7362]

It should be possible to change the column header for the hierarchy also like it was recently added for the header of the slicer.

[@akshaykhiste9104]

Cool trick !!!

[@lakeoffm]

Power BI: doesn’t show the user the ways one can drill down before actually drilling down. Also Power BI: here’s five ways you can do the stuff we haven’t included in our product because we’re busy working on smth else. I personally find the trick great, with only one drawback: it will also show up in the title in the tooltip and can get messed up with titles of other levels.

[@mdhidayat5706]

Ah-ha.. Now why didn't I thought of this approach. Simple yet definitely helps end users .😂

[@rahulmaurya9444]

Wow this trick is owsome 👍

[@eugeneo1589]

I'd prefer to have that field renamed/removed using the Format pane. Especially if your report is connected to a PBI dataset or AAS.

[@MinhTamNguyen-jd3uz]

Does creating a hierarchy mean creating duplicate columns?

[@aerobrain2001]

Ah I was hoping that would be something dynamic :-)

[@mans2522]

What if I want to be able to change column header depending on picked language in a multilingual report? Is this even possible?

[@richard-social8125]

Try qlik

[@bernie2206]

It is possible with translations in Tabular Editor. But I think it's currently working with PBI Premium only (not sure why nor if something has changed, but when I tested it, it only worked in Premium workspace for me).

[@pauloricardoferreira3142]

Congratulations

[@joeseroski1095]

lol wow. I was expecting some kind of ConcatenateX expression.

[@arameshkumar5072]

Cool stuff ❤️

[@driekeijlders281]

Sometimes its just useful too have confirmation that what you are doing is correct :-) Question: what is the advantage of a "powerbi" hierarchy?

[@joeseroski1095]

It's a way to keep fields together. Less Clicky Clicky Draggy Droppy. If you're always putting a few fields together for users to drill down (like Country-State-City), then put them in a hierarchy.

[@venkateshns2003]

suuuuuuuuuper trick

[@jasonwoodward5501]

Boom!

[@lezzrc]

Related Q: Do you know of any tricks or tips I can use that will bring up a small description tool-tip for each column (or, certain columns) of the matrix and table visuals, on hover?

[@Darknesslc3]

What a sneaky dark magic, I thought it was using some kind of path

[@juanpablorvvv]

I thought it was obvious. I have been using it a long time ago. I wonder if they are similar things that are obvious and I don’t know 🤔

[@jimalyajenkins9133]

That’s a trick?

[@vinodvenkatasivaprasadsing9418]

Lol wasted my time 5:22 😀

[@nixland]

You are explaining TOO FAST! Slow down. I don't understand why so many tutor does that, as if they don't want their audience to follow or understand

[@matthewalkman386]

dude... thats not what we need.