使用条件格式设置在Power BI中给单个水平网格线上色。

huangapple go评论73阅读模式
英文:

Using conditional formatting to color to a single horizontal gridline in Power BI

问题

Is it possible to use conditional formatting to color a single horizontal gridline in Power BI? I just want the 0 horizontal line to be black and the rest to be invisible/removed.

我可以使用条件格式来着色单个水平网格线吗?我只想让0水平线变成黑色,其余的都不可见/删除。

I've tried countless formulas and format styles with no success. Not sure if I'm missing something simple or not. Is this a limitation within Power BI?

我尝试了无数的公式和格式样式,但都没有成功。不确定是否漏掉了什么简单的东西。这是Power BI内的限制吗?

When I try to use the Analytics pane to add a constant line, the only options that appears is "Error Bars."

当我尝试使用分析窗格添加常数线时,唯一显示的选项是“误差线”。

英文:

使用条件格式设置在Power BI中给单个水平网格线上色。

Is it possible to use conditional formatting to color a single horizontal gridline in Power BI? I just want the 0 horizontal line to be black and the rest to be invisible/removed.

I've tried countless formulas and format styles with no success. Not sure if I'm missing something simple or not. Is this a limitation within Power BI?

When I try to use the Analytics pane to add a constant line, the only options that appears is "Error Bars"

enter image description here

答案1

得分: 1

要在位置零添加一条水平线并消除其他水平线,请按照以下步骤操作:

  1. 在格式窗格中关闭水平线。
  2. 转到分析窗格(格式窗格右侧)并添加一条常数线。
  3. 您可以为该线添加任何值/颜色。

参考资料:

在Power BI Desktop中使用分析窗格

英文:

To add a horizontal line at position zero and eliminate other horizontal lines, follow these steps:

  1. Turn off the horizontal line from format pane.
  2. Go to Analytics pane (right side of format pane) and add a constant line.
  3. You can add whatever value/color you want for that line.

Reference :

Use the Analytics pane in Power BI Desktop

huangapple
  • 本文由 发表于 2023年4月20日 00:56:46
  • 转载请务必保留本文链接:https://go.coder-hub.com/76057067.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定