We need text value like more or less, but instead of that we are getting 1 or 0 like measures.

[Vishwajeet-Singh]

We need text value like "more" or "less", but instead of that we are getting 1 or 0 like measures. We are creating a story, where have created table where we have to get the value in text like more or less, instead we are getting in number format like 0 or 1, Attaching two image, we need result like 1st image, but in 2nd image we are getting 0 and 1. please provide the solution.

Image1 - What we expect

Image2 - What we are getting

 

[N1kh1l]

@Vishwajeet-Singh 

SAC cannot store textual data into measures. It can only store numeric values. One possible work around could be that you store numeric values for each of those texts like below and then use thresholds to color code them and only show threshold icons. 

2- More

1- Less

0- NA

I do not think its possible to store texts into SAC measures and generate a matrix like you have shown in picture 1.

Nikhil

[Vishwajeet-Singh]

Hey Nikhil, thanks for your input, let me see if it works.