Twbx attached
I've got a pie with four slices. I've got a corresponding list of the segments and how many percentages for each. I am looking for a way to make both the segment name and the corresponding percxentage match the colour of the pie diagram.
It probably makes more sense when opening the twbx -> the dashboard.
Is this possible - without doing daft stuff like creating coloured blocks and sticking them behind the text in the list or similar.
Hi @Lise Kok Petersen
Bit of trickery here. Drag an additional copy of your Category field onto marks card, then right-click and in the contextual menu select Measure then MIN (or MAX), essentially making the dimension a 'measure'. Ensure that it's cast as Text in the Marks Card (click the icon next to the field and select Text from the list of options) changing from just Detail to Text.
This activity will then allow you to click the TEXT Button and then the ... (ellipses on the far right):
From there, a new dialog opens and then set to something like the below, allowing enough space between 'Category' and your actual measure:
Click Apply, then go to Category on Rows in the worksheet; right-click and uncheck Show Header. This keeps the structure of the Category field on rows, but removes the detail, leaving you with just:
Hope that points the way. Give it a go on your own? Best way to learn is by doing.
Best, Don Wise -
Please don’t forget to upvote and/or Select as Best by clicking the hyperlink below in the response that answered your question.
