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.
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
Hi Dog I tried the solution you mentioned of stacked bar chart with one measure that returns a value, and one a percent (multiplied by 0 if it isn't to be displayed). The chart works fine if the individual measures are formatted properly except for the Y-axis, which shows in percent. So I had numbers like 6,400bn% in the y-axis.
It's unfortunate that there isn't a way to dynamically format the y-axes as leaving these as "Auto" is best.
Even bar charts in the new experimental table visual don't work if you use Format(), which is, again, unfortunate.