Forum Discussion
dcimcclelland
4 years agoNew Member
Text Measure not displaying in Visual
Hi, (sorry I'm a novice...) I have created a Measure to return a text string with 6 possible results (depending on which range a calculated result falls into). In Visuals I can create a ...
- 4 years ago
What you can do is create a different measure to each category, and put each of those in the chart.
Each measure Would likely be something similar to:
No Sales= CALCULATE( COUNT(Table[number]), FILTER(Table, [Stock Turn Range] = "no sales" )
SpartaBI
4 years agoCommunity Champion
dcimcclelland think about it, how would you represent texts in charts? What will be the scale?
You can't use charts to show text as the values.
You can however use Calculation Groups to change the format strings of the result to that ever you want, but the actual values need to be numeric.