Power Bi中的交通灯也可用于总计 [英] Traffic lights in Power Bi which work also for totals

问题描述

如何使表格中的交通信号灯可视化，这对总数也起作用？假设我们的KPI是某种比率或份额，例如每个国家的人均GDP ，或者是与商店的预算差异。拥有单个类别的交通信号灯很有趣，但是拥有所有类别的摘要的交通信号灯会更加有趣。

我遵循并在

编辑。似乎是您可以投票的梦想功能。请为它投票！

How to make traffic light in table visual which works also for totals? Let's say our KPI is some sort of a ratio or a share like GDP per capita by countries, or the difference from the budget by stores. It is interesting to have traffic lights for individual categories but it would be even more interesting to have a traffic light for summary of all categories.

I followed and example shown here: The idea is based on adding a DAX measure:

TrafficLight = UNICHAR(11044)

And then we set up conditional formatting for traffic lights based on other column or measure. But the conditional formatting seems not to affect totals. How to have a traffic light which also shows red, yellow, green color for totals?

Edit. Seems to be a dream feature you can vote for. Please do vote for it!

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17401381-conditional-formatting-for-total-and-subtotals-in

解决方案

Since the April 2020 PBI update this is finally possible:

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-april-2020-feature-summary/#_Conditional_formatting

这篇关于Power Bi中的交通灯也可用于总计的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！