flattable | It helps you manage de-normalized tables | Grid library

I have the following data in a flat table with unsummarized data.

Each row in the flat table describes a unique data value collected for a given date and hour of the day.

I would like to do a scatter chart where:

• The x-axis is the hour of the day.

• The y-axis is the measured value.

• The Play-axis is the date.

A snippet of actual data is shown below.

I can get a basic dot plot using the Power BI over all days by setting the scatter chart X and Y to the unsummarized fields.

I can probably create hourly box plots from this data by adding an R visualization.

However, I would like to use the Play Date column as the Play axis and animate the measured hourly values over the date range.

When I add Play Date to the visual as the Play Axis, I get the following error:

The question is: How do I create a Measure that, when aggregated, returns the field value for a row?

I have tried a calculated column based on MAX([field],0). This does not work because the aggregate takes the MAX of the entire table.

• How would I create a Measure that returns a field value for the current row in my flat table when aggregated on a Power BI scatter chart?

• If I must use a filter, will this adversely affect performance?

• Tried creating Measures using the DAX SELECTEDVALUE function. For example:

  HourofDay = SELECTEDVALUE(FlatTable[X])

  HourlyMeasure = SELECTEDVALUE(FlatTable[Y])

This does not work and results in an empty visualization.

• Tried creating a Measure based on the DAX LOOKUPVALUE function.

  ...