Power query problem while extracting day from date by add column option

[rs281105]

Power query problem while extracting day from date by add column option , ih this the whole window is not fitted upto screen of pc /laptop and while extracting day name from date we can't able to get home , view and all necessary tab that the at top of power query (ETL) after extraction of day name from date you can't able to get back to your top tab as much as you can nothing will happen I have wasted lots of time in understanding this problem now finally give you a suggestion to change it becoz all work has to do from starting. Not a single top menu option like home , view, etc are visible no way to go back 

[v-nmadadi-msft]

Hi @rs281105 

As we haven’t heard back from you, we wanted to kindly follow up to check if the suggestions  provided by the community members for the issue worked. Please feel free to contact us if you have any further questions.

Thanks and regards

[rs281105]

Yes the answer is some where some how satisfying thank you 

[v-nmadadi-msft]

Hi @rs281105 

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.

Thank you

[v-nmadadi-msft]

Hi @rs281105 ,

I wanted to check if you had the opportunity to review the information provided @rs281105 . Please feel free to contact us if you have any further questions.

Thank you.

[Royel · Accepted solution]

Hi @rs281105 You’re right, I understand your frustration. This is a Power BI UI issue the "Name of Day" is only about 70% visible at the bottom in Laptop but 100% visuble in Large Monitor. In your case, it might be even less.

Root Cause: There is a high probability you laptop has 125% scale 

if you adjust your device display setting to 100% it will visible perfectly 

Go to your PC Settings -> Display Settings -> Scale & Layout -> Scale 100%

However, Here is the m-code to get the Name of Day from your Date column 

= Table.AddColumn(#"Changed Type", "Day Name", each Date.DayOfWeekName([Date]), type text)

Find this helpful? ✔ Give a Kudo • Mark as Solution – help others too!

[rs281105]

Thanku so much for your wonderful explanation 

[AmiraBedh]

Hello !

Can you please share some screeshots so we can better assist you ? 🙂