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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

year and month in one colum

Hi

 

how can i have year and month to be just in one column?

 

month + year.PNG

thank you

1 ACCEPTED SOLUTION

Hi @Anonymous ,

 

 

To disable date heiararchy,

 

 

 

2.JPG

 

 

Also you can go to Files > Option and Settings > Options >> Current File and disable the auto date time.

 

 

1.jpg

 

 

https://www.sqlbi.com/articles/automatic-time-intelligence-in-power-bi/#:~:text=The%20Auto%20Date%2FTime%20feature%20can%20be%20turned%20on%20or,date%20column%20in%20the%20model.

 

 

Can you share the snapshot of how the dates can imported in Query Editor and Power BI Desktop,

 

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

View solution in original post

4 REPLIES 4
harshnathani
Community Champion
Community Champion

Hi @Anonymous ,

 

 

Measure = Concatenate (MAX('Table[Year]), MAX('Table'[month]))

 

 

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

Anonymous
Not applicable

Hi Harsh

 

this are my data. for each project for the last 4 months i go an expected end date for the project. everytime i try to create a graph Power BI put a jerarchy for each of those dates, whilst i would like Power BI to give me just one value for month and year together

can you help me somehow?

 

Project                  Feb       Mar        Apr         May

SMP PH1             04/20    04/20    08/20    09/20

SMP PH2                            08/20    08/20    09/20

FOCUS                  02/21    12/20    12/21    06/22

 iTRACS                03/20    04/20    04/20    05/20

BAM                     07/21    03/22    03/22    03/22

GCAP​                    01/20    06/20    06/20    09/20

HQ UK                  12/19    12/19    09/20    12/20

eSign                   11/19    01/20    01/20    07/20

ROM1​                   09/21    12/21    02/22    02/22

MBP                     12/20    12/20    12/20    12/20

PCC                       06/20    06/20    06/20    09/20

MWP                    05/20    05/20    05/20    05/20

SABRE                  04/20    05/20    06/20    12/20

NRC                      06/20    06/20    06/20    06/20

ICOLO                                 10/20    10/20

Hi @Anonymous ,

 

 

To disable date heiararchy,

 

 

 

2.JPG

 

 

Also you can go to Files > Option and Settings > Options >> Current File and disable the auto date time.

 

 

1.jpg

 

 

https://www.sqlbi.com/articles/automatic-time-intelligence-in-power-bi/#:~:text=The%20Auto%20Date%2FTime%20feature%20can%20be%20turned%20on%20or,date%20column%20in%20the%20model.

 

 

Can you share the snapshot of how the dates can imported in Query Editor and Power BI Desktop,

 

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

Anonymous
Not applicable

Hi Harsh

 

i have this data:

end date PBI.PNG

i disabled the heiararchy and now i want to have a stacked colum chart that show me the end-date trend per each project but everytime i put the month data (i.e. Feb, March ...) in the Value data the system count them as 1 whilst i dont want to have those data counted bu stacked. 

This is what i get for example for SABRE project, but those bars should be different based on the different end-date reported which in case of SABRE is April '20, May '20, Jun '20, Dec '20...

 

SABRE end date.PNG

can you help me?

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!