問題描述
需要為 Shift-wise 狀態變化數據繪制圖表.我使用 python Jupyter 繪制堆棧條形圖.
jupyter 的示例數據集和輸出如下所示.
輸出:
但是當我要使用 powerbi 堆棧條形圖來繪制它時.它顯示聚合，而不是實際值.
例如:03-01 Day First START >STOPPED>RUNNING>STOPPED 并繼續......在 powerBi 堆棧欄中顯示 STOPPED、RUNNING 和其他狀態(聚合值(總和)而不是實際值與順序).有什么方法可以得到與 jupyter notebook 相同的輸出.
非常感謝您的支持！！！
您需要為每個數據點創建一個具有唯一值的列，例如日期/時間值.然后將該值用于堆積柱形圖的圖例中.
當然，這不會對您的狀態值進行顏色編碼，因此這也不是理想的解決方案.
但是如果 Python 可以生成你想要的圖表，你為什么不在 Power BI 中使用它呢??
Need to plot chart for Shift-wise state change data. I plot the stack bar chart using python Jupyter.
Sample dataset and output from jupyter is shown below.
Output:
But when I'm going to plot this using powerbi Stack bar chart. It shows aggregates ,instead of real values.
Ex: 03-01 Day First START >STOPPED> RUNNING>STOPPED and goes on...... In powerBi stack bar shows STOPPED,RUNNING and other states' (aggregate values(summations) instead of real values with order). Is there any way to get the same output as i have got from jupyter notebook.?
Really appreciate your support!!!
You will need a column with unique values for each data point, like a date/time value. Then use that value into the Legend of the stacked column chart.
That, of course, will not colour code your state values, so that's also not an ideal solution.
But if Python can produce the chart you want, why don't you use that in Power BI??
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-python-visuals
這篇關于使用 PowerBi 可視化移位順序數據的合適圖表的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！