PowerBi中具有多轴的重叠条形图 [英] Overlapping bar chart with multiple axis in PowerBi
问题描述
我想在PowerBi中有一个多轴重叠的条形图。我有一个Excel的示例,如果可能的话,我希望在PowerBi中重新创建。
I would like to have a overlapping bar chart in PowerBi with multiple axis. I have an example from Excel which I would prefer to recreate in PowerBi if this is possible.
这里是示例:
在PowerBi中有可能吗?
Is this possible in PowerBi? Maybe by using a custom visual I don't know off.
在此先感谢
推荐答案
多轴?是!重叠的酒吧?
Multiple axes? Yes! Overlapping bars? No!
使用折线图和群集柱形图
是一种方法:
以下是使用的演示一些随机数:
Here's a demo using some random numbers:
Date A B C
07.08.2018 0,359008828 0,993689927 0,8
08.08.2018 0,127630228 0,449164386 0,8
09.08.2018 0,431825126 0,615830289 0,8
10.08.2018 0,269830973 0,984995499 0,8
11.08.2018 0,27416548 0,64248379 0,8
12.08.2018 0,777712123 0,740108131 0,8
13.08.2018 0,264229043 0,242084953 0,8
14.08.2018 0,49124239 0,144428206 0,8
15.08.2018 0,242050334 0,020032871 0,8
16.08.2018 0,316102617 0,644935538 0,8
- 使用输入数据可以在 Fields下获得包含这些数字的表格:
- Use Enter Data to get a table with these numbers under Fields:
- 在可视化
- Click Line and Clustered Column Chart under Visualizations
<<下单击线和聚簇柱形图 a href = https://i.stack.imgur.com/c0i70.png rel = nofollow noreferrer>
- 拖动
日期
到Shared Axis
,然后使用Date
旁边的下拉菜单将日期层次结构更改为简单日期。
- Drag
Date
toShared Axis
, and change the date hierarchy to simple date using the drop down menu next toDate
.
- 将
C
拖动到线值
和A
和B
到列值
:
- Drag
C
toLine Values
, andA
andB
toColumn values
:
- 在Y轴下,将
Show Secondary
设置为On
- Under Y axis, set
Show Secondary
toOn
据我所知,这与您要复制Excel图表的时间差不多。
And that's as close as you're going to get to replicate your Excel Chart at the time being as far as I know.
这篇关于PowerBi中具有多轴的重叠条形图的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!