Forum Discussion

dogt1225's avatar
dogt1225
Helper III
5 years ago

Creating Column field for Histogram Chart

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

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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