Creating Column field for Histogram Chart

[dogt1225]

I am creating a histogram chart that breaks down the Number of Open Submissions in certain age buckets. I have created a measure that calculates the age of Open Submissions

And created another field to categorize the age into groupings for the histogram visual. Forexample "0-30" days, "31-60" days, "61-90" days etc.

When I create the field as a Measure the calculation work, however if I create as a Column (exactly the same calculation as Measure) everything is grouped wrong. I will need the field as a Column in order to create the histogram visual? Any ideas whats happening? Thanks

[v-eqin-msft]

Hi @dogt1225 ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution to make the thread closed. More people will benefit from it.

Hope to hear from you!

Best Regards,
Eyelyn Qin

[v-eqin-msft]

Hi @dogt1225 ,

To my knowledge, Measures can be dragged to value or tooltips field, but can’t be dragged to legend or X-axis field.So it's suggested to use Caluclate column rather than Measure.

And normally, the usages and returns of DAX functions are different in Calculated columns and Measures.Please provide me with more details about your table or share me with your pbix file after removing sensitive data.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.