Forum Discussion
Creating a Dynamic Calculated Column to use as chart column label
Hello, I want to create a dynamic calculated column which will change the count of number according to my slicer selection. Currently, it showing up the total number from the dataset regardless of ...
If you know the expected range of the measure you can use a disconnected table with the respective buckets to feed the X axis of your visual. In your case the buckets are undefined since your are adding the product count.
You may need to use a different visual , or indeed do this outside of Power BI.
Based on the sample data you provided - what would be the expected outcome?
Note: Joining on the Product Name is unfortunate. Would be better if the Sales Table had a Product Key column.
The expected outcome would match the numbers just like the table showing the breakdown of each sales person Total Product Sales. Such as Aaron should have "Aaron (6)", Abby should have "Abby (2)" etc.