如何使表格中的交通灯可视化,也适用于总数?假设我们的 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!
ideas.powerbi/forums/265200-power-bi-ideas/suggestions/17401381-conditional-formatting-for-total-and-subtotals-in
解决方案Since the April 2020 PBI update this is finally possible:
powerbi.microsoft/en-us/blog/power-bi-desktop-april-2020-feature-summary/#_Conditional_formatting
更多推荐
Power Bi 中的红绿灯也适用于总计
发布评论