Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Young_G_Han
Helper III
Helper III

Dynamic Column Name changed by the selected Year & Month

  Dear Kudos

 

I am converting an old Excel file report to the BI.

 

The old Excel file has many customized columns and cells.

 

One of my missions is to create measures for the following tables.

 

 

Factory  |  Operation  | Last Year Total | Last 13 Month by Month | Current Year Total | Current Year Avg.

 

Above the list is the column header.

The production data refers to many different database files.

 

So there are many rows that measures are not coming from one table.

 

Order

Production

Stock

Priority

 

And so on...

 

So it is not easy to create the table. Furthermore, I would like to change the month and year based on the date slicer.

For example, if I select 2023/Oct by the date slicer, the report should show

 

                    Factory  |  Operation  | 2022 Total | 2022 Oct - 2023 Oct by month | 2023 Total | 2023 Avg.

Order

Production

Stock

Priority

 

Is there a proper approach to make this kind of complicated table by Dax measure?

 

1 ACCEPTED SOLUTION
Dangar332
Super User
Super User

hi, @Young_G_Han 

There no direct posiibility to create such things but you can make a new measure for selected year and make card visual and overlap it in measure or column name

like below
make new measure for selected year only

selected year =
SELECTEDVALUE('Data Date'[Year])
 
make a new card visual and drag above measure here then resize it and disable catagorical label

overlap it on column where you want to use for selected year total and avg. like below image
Dangar332_0-1711970557984.png

here yellow color is card visual after resize it and red color is measure name


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

2 REPLIES 2
Dangar332
Super User
Super User

hi, @Young_G_Han 

There no direct posiibility to create such things but you can make a new measure for selected year and make card visual and overlap it in measure or column name

like below
make new measure for selected year only

selected year =
SELECTEDVALUE('Data Date'[Year])
 
make a new card visual and drag above measure here then resize it and disable catagorical label

overlap it on column where you want to use for selected year total and avg. like below image
Dangar332_0-1711970557984.png

here yellow color is card visual after resize it and red color is measure name


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  Dear Dangar332

 

Nice idea. I supposed that would not be easy.

But your idea is reasonable.

Thank you.

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Find out what's new and trending in the Fabric Community.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.