How to emphasize a specific time point on a time x-axis.

[vminvsky]

Hi,

Overview:

I have an x-axis on a bar graph that is made of 10 minute periods of time throughout the day. 

I did some cluster analysis to cluster the day into periods of high demand. In other words, I have the range of time when demand is high in the morning and I have the range of time when demand is high in the evening. 

For the morning high demand, I want to emphasize the two end points that show the range of high demand. How can I do this? I will also then do this for the evening too.

Thanks ahead of time.

[jdbuchanan71 · Accepted solution]

Hello @vminvsky 

You are looking for something like this?

I needed to add a table with the time groups then a measure to calcualte the groupings.

Grouped Measure = 
CALCULATE (
    [RowCount],
    FILTER (
        VALUES ( 'Table'[Time] ),
        COUNTROWS (
            FILTER (
                Times,
                MAX ( 'Table'[Time] ) > Times[min]
                && MAX ( 'Table'[Time] ) <= Times[max]
            )
        ) > 0
    )
)

The attached file has the sample data and grouping table along with the measure.

[vminvsky]

Thank you!