Forum Discussion

Dunner2020's avatar
Dunner2020
Post Prodigy
5 years ago
Solved

Displaying multiple measures in bar chart

Hi there,   I have data about the time taken to complete activities. I have created a measure that calculates whether the job has done before the estimated time or after the estimated time. Measure...
Need Help
Show and Tell
Tips and Tricks
  • AllisonKennedy's avatar
    AllisonKennedy
    5 years ago

    Dunner2020  Please see attached file (below signature). You need to create the calculation as COLUMN, not Measures. Then right click the new column and choose "New Group" (select edit group to see the grouping I chose).

     

AllisonKennedy's avatar
AllisonKennedy
Community Champion
5 years ago

Dunner2020 I would suggest that you have 1 column that does this binning/grouping for you. There is a histogram visual that will do this grouping for you automatically: https://spreadsheeto.com/power-bi-histogram/

 

Or you can Right click on the Time column in the Report view and select New Group, then group by bin size, 15. For this to work, you'll need the Time to be a COLUMN (not a measure as you currently have it). 

 

Can you share a preview of what your table/data model looks like currently if you need more advice?

AllisonKennedy's avatar
AllisonKennedy
Community Champion
5 years ago

Dunner2020  Please see attached file (below signature). You need to create the calculation as COLUMN, not Measures. Then right click the new column and choose "New Group" (select edit group to see the grouping I chose).