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

1. 使用 Enter Data 在 Fields 下获取包含这些数字的表格:

1. Use Enter Data to get a table with these numbers under Fields:

1. 点击Visualizations下的Line and Clustered Column Chart

1. 将Date拖到Shared Axis，然后使用Date旁边的下拉菜单将日期层次结构更改为简单日期.

1. Drag Date to Shared Axis, and change the date hierarchy to simple date using the drop down menu next to Date.

1. 将C拖到行值，A和B拖到列值:

1. Drag C to Line Values, and A and B to Column values:

1. 在 Y 轴下，将 Show Secondary 设置为 On

据我所知，这与您目前复制您的 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屋！