Forum Discussion
Super UserChanging colors based on rules within ConcatenateX
Hi Power BI experts,
Please could you let me know if there's a function in Power BI where I can change colors within ConcatenateX generated text outputs. For example, my task involves writing variance analysis of numbers and why the balance increased X amount and decreased by Y amount, etc. I'd like to automate this task as much as possible, by using ConcatenateX and searching into journal entry text descriptions for the details of the movements, but how can I change the color of the monetary value where the increase in number is shown in blue color and decrease in number is in red color within the same text ouput generated from ConcatenateX? Is there a technique to change color within the text output? I am currently doing this manually in excel, and it is quite tedious to change colors manually.
Thank you for your insight and knowledge.
Hi DataNinja777
Unfortunately, there is no option to achieve it directly.
I use a kind of embedded cards as a workaround to achieve this effect.
You can take a look at the linked discussion for more details :There is an idea about a similar issue you can vote for / post a new one with more details:
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=fcbcba13-0abd-ed11-9ac5-501ac50aaf16
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi, DataNinja777 again I am afraid that with excel there is no solution as well.
Please refer to the linked discussion :it is also in the Excel community so you can try to post your question with the example there too...
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
6 Replies
- Ritaf1983
Hi DataNinja777
Can you please show the desired output?- DataNinja777
Hi Ritaf1983
Thanks for looking into this request. I am looking for a systematic way to color the concatanateX generated text variance analysis based on the negative or positive of the oringal numbers within the concatenateX constructed scentence. I am writing it manually at the moment, but I believe, this is kind of possible using ConcatenateX with combination of RankX function, but coloring part, I am not sure, if it can be done.
Thanks!
- Ritaf1983
Hi DataNinja777
Unfortunately, there is no option to achieve it directly.
I use a kind of embedded cards as a workaround to achieve this effect.
You can take a look at the linked discussion for more details :There is an idea about a similar issue you can vote for / post a new one with more details:
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=fcbcba13-0abd-ed11-9ac5-501ac50aaf16
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
