Power BI
NewAbility to dynamically (with DAX functions or Measures) assign (data) values to a Format property
John on 02 Aug 2016 01:45:00
Examples:
set Reference Line from a data field value (In PBI Desktop July you now call it Constant Line).
set a color to a line or bar chart when a threshold is crossed
Set title value of a chart from data.
- Comments (3)
RE: Ability to dynamically (with DAX functions or Measures) assign (data) values to a Format property
Trying to use the Analytics Pane on a Scatter Chart, I hit a bug which doesn't display correctly (P10 is shown between P50 and P90), so I added a Multi-row Card to my report to see what values I should see. With these measures calculated, the reasonable thing to do would allow us to add these measures as reference lines to the chart. I can set specific values, but over time and/or as selection changes, I want to be able to use new values with respect to the appropriate window of activity. Fixed constants do not fulfill this requirement.
RE: Ability to dynamically (with DAX functions or Measures) assign (data) values to a Format property
any update?
RE: Ability to dynamically (with DAX functions or Measures) assign (data) values to a Format property
This is a good idea. If I may expand on this idea with my use-case to give another example. I have a static reference line on a bar chart and it's fine, it works. But once my users start to slice (filter) the data, the reference line (obviously) stays static.
In the perfect scenario, I would create the reference line value by using DAX and a measure, and with this approach as a user slices the data that reference line changes based on the filters selected (as it should).
This is about having more control than just the "min", "max", "average" of the "built-in" measure as is the case with the August 2016 update. Where a developer can assign a DAX measure to the dynamic line itself.
This way I have an overall goal (or benchmark) for the organization as a whole, but that benchmark changes by customer segment. So as the users select different filters (again) that benchmark changes.