DYNAMIC COLUMN NAMES IN POWER BI MATRIX VISUALS | SHOW CURRENT AND PREVIOUS YEAR IN COLUMN HEADER

preview_player
Показать описание
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

Our videos are mostly specific to real time challenges faced into Power BI projects and its solutions. We use smart and most efficient techniques to solve such challenging situations in Power BI and DAX.

Checkout our playlist and SUBSCRIBE to our channel, for all such interesting topics in Power BI.

Follow us on LinkedIn
@POWERBIHELPLINE
Рекомендации по теме
Комментарии
Автор

New total sales =
VAR _Sales = Calculate([total sales]),
DimDate[year] = SELECTEDVALUE(‘year in use[year]))
RETURN
IF(
SELECTEDVALUE(‘year in use’[year] IN {MAX(dimDate[year]), MAX(dimDate[year])-1}
_Sales, BLANK()
)

jakob
Автор

Thank You for the solution video, I have also mailed for this query, But in my scenario only one year is showing, Please tell what to do ?plz reply

raveenareddymitta
Автор

Hello, did you change the slicer as well?

buff_panda
Автор

this video just earned a new sub. thank you!

birasafabrice
Автор

Nice Work, it is working as expected Thank you

rajasekharkapparapu
Автор

Thank you for the solution
What if i want to include also the vatiance (difference ) of the 2 columns? How can i include this in the headers?

omarbn
Автор

Thank You for the solution video
But in my scenario only one year is showing, Please tell what to do ?

AnandKumar-ywnp
Автор

I have also mailed you for this query (Can we change dynamically column name in Matrix.
suppose if we select any month in slicer in table matrix need to show previous month budget along with coloum name. ex- if i select january FY23 in slicer in my visual december F23 will need to show )

Can you help me with the same

dikshasrivastava
Автор

I have achieved similar thing ....but the problem is it is working fine in Power BI desktop but when I am publishing in Report server, it is not working at all....why is it so?. Please reply...it is very urgent 😢

subhasreegupta
Автор

Hi PBI Helpline,
How to change the column name instead of just showing year.? (URGENT)

chonghongyi
Автор

Can we change dynamically column name in Matrix.
suppose if we select any month in slicer in table matrix need to show previous month budget along with coloum name. ex- if i select january FY23 in slicer in my visual december F23 will need to show .

meghab
Автор

Hello, this solution is not working. Can you help?

alsapeter
Автор

But there is a problem in this, you cannot sort the the table by any of the header

foxysatisfying