Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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!
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!
Thank you so much. Made it into a calculated column, that did the trick.😙
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
37 | |
25 | |
19 | |
14 | |
8 |
User | Count |
---|---|
69 | |
48 | |
44 | |
18 | |
15 |