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

问题描述

我有2个时间序列的数据，一个是月度值，一个是每周值。当我扩展到所有1级时，它确实可以满足我的要求，但不能正确显示月度值。

有什么办法可以让我图表在同一张图表上显示一组数据的月度值（和几个月），而另一组数据的周度值呢？

某些样本数据

每月/年Sigma
2019年10月5
2019年11月5.5
2019年12月4.5
2020年1月4.75

周数缺陷
43 6
44 4
46 5
51 10
1 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屋！