Number Formatting Expression Works in PivotTable but not Line/Bar Chart
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?
Re: Number Formatting Expression Works in PivotTable but not Line/Bar Chart
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?