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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
NGC48
Helper I
Helper I

Power BI Desktop Dark Mode issue in Power Query

Hi , I have recently swithced on the Dark Mode Preview. I have found that whenever I apply the Dark/Light mode preview, the abilty to use the Date functions such as subtraction are disabled from the ribbon in Power Query. I have uninstalled & reinstalled with the same out come. As soon as I go back to the default mode evrything works OK

Has anyone else suffered the same issue?

 

Regards, NGC

3 REPLIES 3
NGC48
Helper I
Helper I

Thanks Leroy Lu, but that is not my issue. It is with the built-in ribbon feature. I am using the latest version of Power BI Desktop

Add Column DateTime functions disabledAdd Column DateTime functions disabled

Regards, Noel

Hi,  @NGC48 
Thank you for your prompt reply.

 

1.Firstly, I need to inform you that there was another version update just yesterday. Here is the link to the latest version:

vlinyulumsft_0-1729676127009.png

 

Download Microsoft Power BI Desktop from Official Microsoft Download Center
 

2.Secondly, to be honest, I encountered your issue during my testing for a period of time: after selecting multiple time-type columns in Power Query, the functionality of the date function was not displaying. However, after further testing, this issue seemed to resolve itself.

 

Therefore, I would appreciate your assistance in conducting the following checks in dark mode:

 

Create multiple time-type columns and select them multiple times to see if the date function consistently fails to display.

 

Test other PBIX files to determine if the same issue occurs.

 

Check if clicking on a single time column displays correctly; if it does, this could serve as a workaround.

 

I hope you can assist with these tests when you have the time, as my testing indicated that this might be a temporary issue, which could have been fully resolved in the latest version. However, if the problem persists, we will need to investigate further.

 

3.Finally, if issues remain after your testing, please feel free to share your feedback using the link provided below.

Microsoft Forms

 

Best Regards,

Leroy Lu

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

v-linyulu-msft
Community Support
Community Support

Hi, @NGC48 

I can understand your frustration; however, I haven't encountered any issues in my current tests. Here’s my testing process:

 

My sample data is as follows:

vlinyulumsft_0-1728971205477.png

1.Firstly, I used a custom column in Power Query to subtract two time columns.

vlinyulumsft_1-1728971205478.png

2.Secondly, I employed a custom date subtraction function.

let
    DateDifference = (startDate as date, endDate as date) =>
    Duration.Days(endDate - startDate)
in
    DateDifference

Then, I used this date function to perform the subtraction.

vlinyulumsft_2-1728971258942.png

vlinyulumsft_3-1728971258943.png

3.Thirdly, I created a new query for date subtraction directly.

vlinyulumsft_4-1728971271486.png

4.My current version is as follows:

vlinyulumsft_5-1728971271486.png

We cannot rule out the possibility of a version issue, so I recommend upgrading your version according to your needs. Here’s the download link:

Download Microsoft Power BI Desktop from Official Microsoft Download Center

 

Of course, if I have misunderstood the date subtraction function you mentioned, please feel free to correct me.

 

I look forward to your reply.
 

Please find the attached pbix relevant to the case.

 

Best Regards,

Leroy Lu

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

 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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