Forum Discussion
Format causing measure to return blank.
I can't share the file but I will work on building a comparable file that has the same data model layout and see if I can reproduce the issue.
I just tested the histogram bucketing and formatted measure in a table (rather than just a bar chart with labels) and it works fine, so now I don't know why it's not working properly with the bar chart. I believe the issue is that FORMAT() returns a text value, which the bar chart doesn't know is actually textual representations of numbers.
Sorry just noticed that yours isn't just percentages.
you're not kidding, I went round in circles on this one.
the only thing I had considered although never followed it through was to have a stacked bar graph that has two outputs one for percentage values and one for the numerical values.
depending on slicer selection would depend on which one had data in to show on the graph - I'm assuming that it would then allow you to format the measures independently.
If I give it a go I'll let you know.
Dog
Dog That's an interesting idea; let me know if it works. I wonder if the "auto" scaling for the chart is "smart" enough to switch between Percent and General (with scaling) if you do this!
Hi spotpuff
it does and doesn't :)
for me it will actual work fine as my client prefers data labels to the axis.
Data labels update accordingly and the correct format is shown for currency or percentage.
The X Axis though is not clever enough as it displays, I assume, based on the first measure passed through in the values list which in my test case is currency (regardless if there are any values or not)
Sorry
Dog