Combine text and values on graphs

[bbioteprera]

Hello everyone.

I am a complete beginner, so pardon my question if it's recurrent, but I didn't find it!

I have a question, and would like to know whether it is possible or not.

I am monitoring some values that I get from log files off of software results.

The values are the following :

- Time when the value got returned

- Measured value

- Aimed value

- Status : OK/KO text

I would like to combine all these and have a graph that shows that when the Measure value is higher than the Aimed value, the status goes from OK to KO, but so far the text gets automatically translated into numerical values and I would like to show it as points or keep it as a text.

Is it possible?

Thanks

MG

[bbioteprera]

Dear Gao, thank you for your feedback.
Here are the data I am using.
I would like to show on the right side of the graph (Y axis) the OK and KO status of each parameters as a text.
But I cannot seem to do that, because it turns the OK/KO into numerical values.
Could you help again please?

Best regards,
MG

[v-cgao-msft]

Hi @bbioteprera ,

Please consider providing some sample data and expected output.

How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly

We can use some functions to combine text.

CONCATENATE function

We can also use the concatenation character (&) to combine text.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum