Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
We have a list with conversations see example below.
Each conversation has an unique conversationID
We want to know that a new conversation has started by giving each conversationid a color
is this possible, I can not find out how...
from | to | message | date | sentiment | conversationid |
Annemie | sam | test | 18/11/2018 | 5 | 8we1841de |
Annemie | sam | test | 18/11/2018 | 5 | 8we1841de |
Annemie | sam | test | 18/11/2018 | 5 | 8we1841de |
Annemie | sam | test | 18/11/2018 | 5 | 8we1841de |
Annemie | sam | test | 18/11/2018 | 5 | 8we1841de |
Annemie | sam | test | 18/11/2018 | 5 | 5qe1873be |
Annemie | sam | test | 1/01/2019 | 5 | 5qe1873be |
Annemie | sam | test | 1/01/2019 | 5 | 5qe1873be |
Annemie | sam | test | 1/01/2019 | 5 | 5qe1873be |
Annemie | sam | test | 1/01/2019 | 5 | 5qe1873be |
sam | annemie | test | 1/01/2019 | 5 | 5qe1873be |
sam | annemie | test | 1/01/2019 | 7 | 5qe1873be |
sam | annemie | test | 1/01/2019 | 7 | 5qe1873be |
sam | annemie | test | 1/01/2019 | 7 | 5qe1873be |
sam | annemie | test | 1/01/2019 | 7 | 5qe1873be |
sam | annemie | test | 2/01/2019 | 7 | 9qs7848be |
sam | annemie | test | 2/01/2019 | 7 | 9qs7848be |
sam | annemie | test | 2/01/2019 | 7 | 9qs7848be |
sam | annemie | test | 2/01/2019 | 7 | 9qs7848be |
sam | annemie | test | 2/01/2019 | 7 | 9qs7848be |
sam | annemie | test | 2/01/2019 | 7 | 9qs7848be |
I'm afraid in format pane of table chart, there's no such option currently. As a workaround, you can create a measure like below to set color in advance for every id:
Color = SWITCH ( TRUE (), MAX ( Table1[conversationid] ) = "5qe1873be", "#b20000", MAX ( Table1[conversationid] ) = "8we1841de", "#ffc04c", MAX ( Table1[conversationid] ) = "9qs7848be", "#a500ff" )
Then click format-> conditional format-> select conversationid-> configure background color like below:
The result is like this:
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
this could be a solution if there where a limited number of unique ID's but it is an evergrowing where lines are added automatically as conversations with our chatbot continues. They want to decide the sentiment score of each line in the conversation and see that score in a graph, so it is not possible to combine the values of each conversation in one line.
And it is not possible to determine the unique id's in advance.
Maybe its just not (yet) possible, but I guessed asking cant hurt 🙂
As you mentioned, unfortunately I'm afraid this couldn't be achieved currently, actually it's a good feature so I would suggest you to post your idea here to help power bi be improved, your contribution will be appreciated.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |