cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
codfail Frequent Visitor
Frequent Visitor

Dynamic Column Headers

Hello all,

I have a question regarding column name changes. I am trying to build a report that will give quarterly data and would like the month names in the matrix column headers to change accordingly. 

For example:
       when Q1 then mnth1=Jan, mnth2 = Feb, mnth3 = March
       when Q3 then mnth1= Jul, mnth2 = Aug, mnth3 = Sep

 

Months.JPG

 

 

Has anyone ran into this before or have an idea on how to do it?

 Thank you for the help in advance!

2 REPLIES 2
Microsoft Eric_Zhang
Microsoft

Re: Dynamic Column Headers

@codfail

There's no such dynamic column name in Power BI, AFAIK. However you could play matrix visual with some tricky. See mode details in the attached pbix.

 

Capture.PNG

 

Capture.PNG

codfail Frequent Visitor
Frequent Visitor

Re: Dynamic Column Headers

Hello @Eric_Zhang,

Sorry for the late response (needed admin's permission), but it didn't work for me. Your example seems to do what I wanted, so it may be due to the way my data is set up and I may just need to change a couple things. Thank you for your help!

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors