Clustered Column Chart Question

[Anonymous]

Hello,

I am trying replicate the following chart (or as close as I can in Power BI) and allow the periods to be user defined or require minimal effort to change the periods. Thanks in advance for any guidance on this request.

Here is an example of my raw data;

[selimovd]

Hey @Anonymous ,

you can create a measure for each "bucket":

Duration 30 Min or less =
CALCULATE(
    COUNTROWS( myTable[Event ID] ),
    myTable[Lane Blockage Duration] <= 30
)

If you want to make that selection more dynamic add a what-if-slicer and instead of the number (30 in this case) use the SELECTEDVALUE from the what-if-slicer.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Anonymous]

I got this to work;

Duration 30 Min or less =

CALCULATE(

COUNTROWS( 'eventsList Total' ),

'eventsList Total'[Lane Blockage Duration] <= 30

)

But I ran into an issue for the Greater than 30 Less than 2 Hours measure. How do I set that up?

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 

Try measure as below:

Duration Greater than 30 Less than 2 Hours =
CALCULATE (
    COUNTROWS ( 'eventsList Total' ),
    'eventsList Total'[Lane Blockage Duration] > 30
        && 'eventsList Total'[Lane Blockage Duration] <= 120
)

Best Regards,
Community Support Team _ Eason

[Anonymous]

That worked great...thank you so much!

That being said, any suggestions as to how I could create this bar chart?