如何在 Power BI 双轴图表上获得每周和每月数据? [英] How to have weekly and monthly data on Power BI dual axis chart?

问题描述

我有 2 个时间序列数据，一个是每月值，一个是每周值.当我将所有级别扩展"到 1 级时，它会按照我的意愿进行操作，但无法正确显示每月值.

有没有一种方法可以让我在同一图表上显示一组数据的月度值(仅几个月)和另一组数据的周值?

一些示例数据

月/年西格玛2019 年 10 月 52019 年 11 月 5.52019 年 12 月 4.52020 年 1 月 4.75

周数缺陷43 644 446 551 101 8

解决方案

PowerBI 视觉效果以特定粒度工作.您可以拥有每月和每周系列，但它们不会适合"一个视觉效果，除非您可以在两者之间建立相关性，例如，将您的每周系列滚动到每月.然后你可以在同一个月轴上显示这两个系列.如果无法关联，则需要使用vanilla PowerBI"的两个图表.

有一个

I have 2 time series of data, one that is a monthly value and one that is weekly. When I "expand" all down 1 level it kind of does what I want but it doesn't properly show the monthly values.

Is there a way I can have a chart that shows the monthly values (and just months) for one set of data and weekly values for another set of data on the same chart?

Some Sample Data

Month/Yr Sigma Oct 2019 5 Nov 2019 5.5 Dec 2019 4.5 Jan 2020 4.75

WeekNum Defects 43 6 44 4 46 5 51 10 1 8

解决方案

PowerBI visuals work at a specific grain. You can have monthly and weekly series, but they will not "fit" on one visual unless you can build a correlation between the two, for example, rolling your weekly series up to monthly. Then you can show both series on the same monthly axis. If you can't correlate, you will need two charts using "vanilla PowerBI".

There is a PowerBI feature request that you can upvote for a 3 axis chart, please do.

You can use R to achieve a three axis chart, however you lose ability to control styling through PowerBI themes.

Also, explore this option on PowerBI.Tips charts

or look in Appsource for 3rd party options, an example below - I am not affiliated with the vendor in the image, nor used their product.

这篇关于如何在 Power BI 双轴图表上获得每周和每月数据?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！