Daniel Otykier

My feedback

  1. 288 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 » Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Otykier commented  · 

    We should also be able to choose the background color of selected items. Right now, they are always black, and this may not look good with the overall theme of the report.

    Daniel Otykier supported this idea  · 
  2. 82 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 » Reports  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Otykier commented  · 

    The idea was actually inspired by a client who works in healthcare: She had a dataset containing a single table with patient diagnoses. If a patient had multiple diagnoses, he/she would appear with multiple records in the table.

    Her #1 request was this: Given a list of patients obtained by filtering on a specific diagnosis, what are the top 3 *other* diagnoses present on those patients? Today, she works around this issue by manually exporting the list of patients into a .csv file, which she then re-imports using PowerQuery, to use as a lookup/filter table on the original diagnoses-table in the dataset. This is rather cumbersome and time consuming, as she needs to perform this export/import operation whenever she wants to consider a new list of patients.

    An option to create a new filter based on the column of an existing matrix/table visual, would solve this problem in a very elegant way.

    Daniel Otykier shared this idea  · 
  3. 4,376 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    195 comments  ·  Power BI Ideas » Premium  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Otykier supported this idea  · 
  4. 18 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 » Reports  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Otykier commented  · 

    And not just the frequency, but the schedule as well (e.g. every day at 8 AM)

    Daniel Otykier commented  · 

    Yes - we definitely need this. One of my client has an Azure Analysis Services model that gets refreshed several times per day. Power BI limits the subscription to no more than once per day, and that is absolutely fine - we just want to control at what time during the day, the email is sent.

    Daniel Otykier supported this idea  · 
  5. 81 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    7 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Otykier supported this idea  · 
  6. 2 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 » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Otykier shared this idea  · 
  7. 652 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    26 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Otykier commented  · 

    Power Query is an incredibly powerful ETL tool. Opening it up, so that it could be used to load data outside of Excel/Power BI/SSAS Tabular would probably make it the best ETL tool in the WORLD! This is a must!

    Daniel Otykier supported this idea  · 
  8. 4,306 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    98 comments  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Otykier supported this idea  · 
    Daniel Otykier commented  · 

    For measures alone, you can actually use Tabular Editor https://tabulareditor.github.io/, although it is unsupported. Tabular Editor lets you connect to a running instance of Power BI Desktop, or to open a .pbit file. You can also export/import measure properties (such as format strings, descriptions, expressions) to a .TSV file for batch editing in Excel. See https://github.com/otykier/TabularEditor/wiki/Useful-script-snippets#export-object-properties-to-a-file for more details.

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

    We’ll send you updates on this idea

    28 comments  ·  Power BI Ideas » Reports  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Otykier supported this idea  · 
  10. 2,295 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    1 comment  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Otykier supported this idea  · 
  12. 16 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Otykier commented  · 
  13. 171 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    13 comments  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Otykier commented  · 

    This idea is extremely under-appreciated. To help others searching for the same feature, let me add some additional keywords that hopefully clarifies the point of this (so the idea can get the votes it deserves):

    - Dynamic table
    - Shared table variable
    - Table-valued measure
    - Reuse table variable
    - Global filter context
    - Shared filter context
    - Reuse filter context

    Let me try to explain why this feature would be immensely powerful and useful to all sorts of Tabular modeling:

    1. Encapsulation of filtering logic into reusable pieces:

    Within the context of a single measure or calculated column, DAX variables are incredibly useful for logic that needs to be reused several places. It makes the code more readable, and my experience is that Formula Engine performance also improves through the proper use of variables. For logic that depends on a single value, today we can easily use intermediate measures to achieve encapsulation, and reuse logic across several measures. However, we don't have a way of doing the same thing for logic that depends on a filter context, which means that you will often need to do the exact same table calculation or filtering in multiple measures and calculated columns, making the solution more cumbersome and difficult to maintain. If the logic changes slightly, the change needs to be manually applied to several objects.

    2. Simulation of SCOPE statements in DAX

    One of the most powerful features of Analysis Services Multidimensional is the MDX SCOPE statement, which is not available in Tabular. Using SCOPE allows us to change the context over which MDX expressions are evaluated. One obvious usage is the DateTool time intelligence pattern (http://sqlblog.com/blogs/marco_russo/archive/2007/09/02/datetool-dimension-an-alternative-time-intelligence-implementation.aspx). Today, in Tabular, we can achieve a similar thing using a Tool dimension, but the downside is that we need to add calendar filtering logic within every single measure. If we had a way of defining a global table variable, we could perform the filtering of the calendar table once, and then reuse it across all of our measures, as exemplified by Scott.

    3. Specifying query-scoped filter context

    Taking this one step further, I would suggest a new Table property where a filter context for the particular table could be specified with DAX (similar to the arguments of CALCULATETABLE). This filter context would then be applied and cached every time a query hits the model, not unlike how Row-Level-Security works today. This feature would make it even easier to implement stuff such as Time Intelligence, Default Member selections, etc. (things that we would implement using SCOPE in MDX), and keep our measures completely clean.

    4. Performance gains

    When modeling complex logic in DAX, performance is always a consideration, and most of the times, performance hits come from complex logic that must be executed in the Formula Engine. Being able to encapsulate logic should help the Formula Engine create more intelligent executions that should perform better, to avoid the same calculations being performed several times.

    Daniel Otykier supported this idea  · 
  14. 81 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    13 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Otykier commented  · 

    It seems that Power BI is already sending the LocaleIdentifier as part of the live connection, but it always has value 1033 (en-US), regardless of which language has been chosen for the UI in PowerBI.com, or which language the browser/OS is using.

    Ideally, the connector should use the LocaleIdentifier corresponding to the UI language of Power BI, or at least provide an option to customize this in the data source, as suggested by Marco.

    Daniel Otykier supported this idea  · 
  15. 3,508 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    62 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…

    Daniel Otykier commented  · 

    An option to "inherit" the formatting of the source measure would be nice. But it would be even better if a more general solution was provided, similar to how SCOPE statements work in SSAS multidimensional.

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    48 comments  ·  Power BI Ideas » Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Otykier commented  · 

    Should be quite simple to add this to the "Selection Controls" section of the format properties.

    Daniel Otykier supported this idea  · 
  18. 30 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Power BI Ideas » Reports  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Otykier supported this idea  · 
  19. 594 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    87 comments  ·  Power BI Ideas » Reports  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Otykier supported this idea  · 
  20. 575 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 →
    Daniel Otykier supported this idea  · 
← Previous 1

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.