Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Clustered Column Chart Question

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 an...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    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

v-easonf-msft's avatar
v-easonf-msft
Community Support
5 years ago

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's avatar
Anonymous
Not applicable
5 years ago

That worked great...thank you so much!

 

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