Dynamic Names in Column Header is POSSIBLE⚡ Selected Year, Previous Year & Variance All - Power BI ✨

Yes it is Possible to have a dynamic column header for your Matrix visual. Earlier also we have posted a video, as how to show selected year and previous year in column header. In this video I will show how you can show selected year name, its previous year, and then variance, all in one single DAX measure.

In This Video -
- How to show dynamic fields in column names of Matrix visuals in Power BI
- Show selected year and previous Year on column header
- You can apply these same techniques for many Power BI native visuals.

Get Help into Questions Related to #powerbi , #dax , #powerquery Power BI #datamodeling , #analysisservices and #powerbiservice

Follow us on LinkedIn
@POWERBIHELPLINE

[rahulkodali]

Great job. We want more videos on this kind of topics which is not available in internet.

[victhorc.f.]

Thank you!, the sort order for the table was a pain for me, but I got it!

[shreedharan.moorthy]

Wow what a way you create dynamic column measure with such ease.
Big shout out.
Only trouble i am facing is, your speed at which you go with your problem solving. I take time to understand.
Could you possibly slow ?

[PBI_elephant]

Great video! I spent a long time managing to do this, but with dynamic dates. It all works well now thanks!
But i was wondering. How can you apply this with multiple year selections? If you select years multiple now, the variance columns sums them all. It would however be preferable to have the variance show in between each year selected, as its own calculation

[VictorHugoEspino]

Excellent, as usual; thanks for sharing.

[padmakarreddy]

Great, Thanks for sharing!
Can we have a video on this CurrentMonth, PreviousMonth, and Variance?

Appreciate your help!!

[raghavanp]

This is super cool! Thanks for sharing

[btissamaouna]

Thank you for sharing;
How we can add another column (percentage of column total) in the same matrix please?

[Jon-mlul]

Thank you very much for sharing knowledge. This tutorial has helped me a lot. How could you do exactly the same thing but putting in the visualization calculated measures in the rows and that the columns show the same information as in the tutorial (Year, Year-1 and % Variation). Do you have a tutorial that explains it? Thank you very much for the help

[chasingdaylight]

Hello! This is a really great approach, but I'm having some trouble implementing it. The two year columns are appearing correctly in my matrix. However, the variance column is not. When I use the code as written, the variance column doesn't show up in the matrix. I removed the first IF statement in the code (the one ending in BLANK()), and now the column appears. However, there are no values in it. Do you have any ideas what might cause that? Thank you!

[GaryClutterbuck]

This is a great video - thank you for posting. Can this be adapted to show only one column based on a slicer selection? E.g. If I have a slicer in which a user can select a country name, can the matrix show the values for the selected country in a column and the Country name displayed as the matrix column heading?

[amitsawant]

Hi,
I have created a Matrix chart in power bi, which has last 5days date as column, departments as rows and sales data as values. I want a single column to display average of my sales in a single column for each row to check what is the average sales in last 5 days for that particular department. Please make a video on this..

Please give me solution ASAP. It's urgent

[myplace]

Can we built Year to Date and Previous Year to Date with Dynamic years?

[agg]

Hi,
How do I sort the variance column in desc/asc order? Thanks!

[maazyousufkhan]

It is possible if I am selecting any month selected month showing sales unit sold and profit and other previous month showing only sales and unit sold (in unit matrix)?

[SDrent-ehct]

Where can I find/download the Contoso file??