Cannot visualize measures created in bar chart and histogram

[Vsthesound]

Hi guys, 

Im currently stuck with trying to visualize customer groups created using measures. It displays perfectly as a table but not as a barchart or histogram. Please see sample as table below.

I think the problem is with the Format when I created the measures, but I dont know what to do to change it. Pls any help would be highly appreciated.

[Shaurya · Accepted solution]

Hi @Vsthesound,

I don't think it's the formatting that's the issue. You have created a measure for finding the Customer Group for every account that you have. This is working fine in the table visual where you are pulling in the account number and score as well. However, in other visuals like Bar or Column charts, the same measure wouldn't be able to aggregate other fields by using Cutomer Group as a category since it is missing the row context.

I suggest you create a calculated column instead of a measure and then add your visuals.

Did I answer your question? Mark this post as a solution if I did!

[Vsthesound]

Thank you so much. Made it into a calculated column, that did the trick.😙

[Shaurya]

@Vsthesound You're welcome!