英文:
How to use a color scale in a power bi donut chart
问题
My data looks something like this:
|动物 | 观看数 |
|猫 | 7 |
|鸡 | 12 |
|牛 | 17 |
|狗 | 28 |
|山羊 | 36 |
但可能会有一些未知的其他动物，而观看数通常不会像这个例子中加起来等于100。
我的甜甜圈车会随机选择颜色。
由于我不知道未来会出现哪些动物，所以我不想创建一个像这样的度量：如果动物等于山羊，则为绿色...
我的目标是像这样的效果：
是否可能只选择一种颜色，比如紫色，然后随着观看数减少而变得越来越深？或者创建一种度量方法，根据观看数的排序来计算颜色代码？
请告诉我。
英文:
My data looks something like this:
|Animal | Viewes |
|Cat | 7 |
|Chicken | 12 |
|Cow | 17 |
|Dog | 28 |
|Goat | 36 |
But there can be an unknown numer of other animals and the Views usualy don't add up to 100 like this example.<BR>
My donut cart chooses the colors randomly.<BR>
<BR><BR>
Since I do not know what animals will apear in the future I do not want to make a Measure like:<BR>If Animal equals Goat then gren...
<BR><BR>
My goal ist something like this:<BR>
<BR><BR>
Is it possible to just choose one color like violet and let it get darker and darker the smaler the number of Views gets?<BR>
Or to create some kind of measure that calculates the color code dependeing on the sorting order of the number of Views?<BR><BR>
Please let me know.
答案1
得分: 2
可以的。您只需构建一个柱状图，然后在图表的列上，您可以使用fx按钮设置颜色。然后，您可以使用格式刷将颜色从柱状图传递到饼图上。这将应用于饼图的颜色比例尺。
英文:
It is possible now. You just have to build a bar chart then on the columns of the chart you can set the colors by using the fx button.<BR><BR>
Then you can use the format painter to tranfer the colors from bar-chart to the pie-chart.
This will apply the color scale on pie-charts.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论