Michael

My feedback

  1. 3,810 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  74 comments  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
    Michael supported this idea  · 
  2. 106 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  5 comments  ·  Power BI Ideas » Dataflows  ·  Flag idea as inappropriate…  ·  Admin →
    Michael supported this idea  · 
  3. 60 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Power BI Ideas » Dataflows  ·  Flag idea as inappropriate…  ·  Admin →
    Michael supported this idea  · 
  4. 81 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    8 comments  ·  Power BI Ideas » Reports  ·  Flag idea as inappropriate…  ·  Admin →
    Michael supported this idea  · 
  5. 17 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
    Michael supported this idea  · 
  6. 23 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Power BI Ideas » Dataflows  ·  Flag idea as inappropriate…  ·  Admin →
    Michael supported this idea  · 
  7. 267 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    29 comments  ·  Power BI Ideas » Reports  ·  Flag idea as inappropriate…  ·  Admin →
    Michael supported this idea  · 
    Michael commented  · 

    So much needed, especially as not all countries flip to DST on the same date in the year.
    E.g. we receive data from a server located in Seattle. So the timezone of the data is Pacific Standard Time (PST = GMT -8) until 10 Mar 2019. Then it switches to Pacific Daylight Time (PDT = GMT-7) until 3 Nov 2019, to then switch back to PST.
    To make it worse, e.g. users in the UK switch to British Summer time (BST = GMT+1) on 31-Mar-2019 and flip back on 27-Oct-2019 (GMT+0). So most of the time we are 8 hours apart, but late March / early April and late October / early November it gets very tricky.
    And if you think this is not complex enough, Europe is already discussing to permanently scrap DST in the EU soon. So even if you build your own query logic with hard coded dates when DST starts/stops by country, you can rework this logic again in every model when things change.

    Thus offering a solution to 'select a timezone' will only work if combined with selecting whether 'DST is enabled or not' in that timezone. Also, when converting from one timezone to another, the DST flag must be available for both the source and the target value separately.

    So I like the idea of Eric Thomas for a simple text string conversion, but would add another (optional) DST parameter.

    ##############
    How about an option to SELECT THE TIMEZONE and DST ENABLES when converting a UTC Text Column to DATE-TIME?

    - Right click column
    - Select Date-Time
    - Choose Timezone (i.e. for GMT-8 for Pacific Time, so always use the 'standard' time)
    - Choose DST Enabled (True/False, this shall adjust GMT offset by -1/0/+1 based on current date)
    - Click Apply
    - Time is converted correctly!
    #################

    And to make it really generic, I suggest to add an optional DST parameter to all the DateTimeZone() functions. Or even add a new set of DateTimeZoneDST() to the M language with the extra DST flag. In fact there must be two DST flags added, one for DST source, and one for DST target, i.e. is DST enabled for local system time, as the 'culture' parameter won't know this.

  8. 256 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    20 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    Michael commented  · 

    So needed, and it shall support both One-Drive and One-Drive-For-Business folders and sub-folders. And you want to be able to author it in PBI Desktop, and then publish to PBI service seamlessly. It should probably work similar to the SharePoint folder connector, which returns a list of files. Those can then be filtered and transformed, e.g. by adding a calculated column with the Excel.Workbook() function.

  9. 253 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    Michael supported this idea  · 
  10. 569 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    27 comments  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
    Michael supported this idea  · 
  11. 214 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  Power BI Ideas » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Michael supported this idea  · 
  12. 18 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    Michael supported this idea  · 
  13. 1,322 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    142 comments  ·  Power BI Ideas » Reports  ·  Flag idea as inappropriate…  ·  Admin →
    Michael supported this idea  · 
  14. 130 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
    Michael supported this idea  · 
  15. 3,190 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    58 comments  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →

    From the comments and scenarios everyone’s describing, the problem is really that you need a way to allow end-users to change which measure is displayed in a visual on the fly.

    As a few folks have mentioned, the FORMAT function might help in the interim, as long as you’re showing the results in text rather than a chart. https://docs.microsoft.com/en-us/dax/format-function-dax has details on how to use that.

    The expression-based formatting feature that we’ve started work on may help to a certain extent, but that’s really designed to change a visual’s properties rather than the data type or format. We’ll look into extending that work to support this scenario as well.

    We’re moving this to Backlog status – our core plan is to build ways that end-users can change the dimensions or measures that are visible in a chart on the fly. They’ll be able to explore much more freely rather than…

    Michael supported this idea  · 
  16. 233 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    14 comments  ·  Power BI Ideas » Analytics  ·  Flag idea as inappropriate…  ·  Admin →
    Michael supported this idea  · 

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.