Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Howdy! This expression is included in my master item to return a number format based on certain conditions in the visual or selections. It works perfectly in my PivotTable but doesn't work at all in the line or bar chart. All charts have the measure set to "auto" number formatting. However, when I replace the function with a standard format, such as '#,##0.0%', it works in the line & bar charts. Any ideas why my custom expression doesn't work in the line/bar chart but does in the pivottable?
That might work ok for individual values for value labels, but there is only one y axis on these charts, so it can't change based on individual values.
Lisa,
I appreciate the quick response. In the bar or line chart, only one type ($ or %) of values should be shown at any one time. $ and % will never be mixed but can be one or the other depending on what dimensions are included in the visual. Conditional statements within the measure determine what format encoding to return. Are you saying that bar/line type visuals are able to decipher those conditional formatting statements the same way the PivotTable does?