Forum Discussion
Combine text and values on graphs
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
2 Replies
Hi Anonymous ,
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 QuicklyWe can use some functions to combine text.
We can also use the concatenation character (&) to combine text.
Best Regards,
Gao
Community Support TeamIf 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
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