Forum Discussion
Super UserChanging colors based on rules within ConcatenateX
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
Super UserHi DataNinja777
Can you please show the desired output?
Super UserHi 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
- DataNinja777
Thanks for your idea Ritaf1983 . I'd appreciate it if anyone could let me know how I can achive this in Excel, and if there is a technique which can take care of this task for me in Excel.
- Ritaf1983
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