Forum Discussion
Creating a Dynamic Calculated Column to use as chart column label
Hi lbendlin , Thanks for looking at my post. Yes, you're right that is essentially a mesure and using measure could solve my problem. However, I want to use this calculated column as an X axis for my column/bar chart. Since I cannot use measure as an X axis, I need to have either a regular column/calculated column to show my audience their relevant total amount based off of the filter selection.
I added one Power BI File , where I tried to wirte a calculated column for the sales person which supposed to ideally show the relevant number based off of the slicer selection. I also include one card visual which is showing the total sum. In that case, the total sum of all columns should match that number.
I am afraid of Power bi may not allow what I was trying to accomplish, but alternative solution with similar outcome would be appreciated.
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.
You need to abandon that idea, it is not possible in Power BI. What you can do instead is put the [Total Product] measure in the tooltips.
