Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

suitable graph to visualize shift wise ordinal data

 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.?

Need Help

1 Reply

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    5 years ago

    Hi Anonymous ,

     

    One question regarding you data does the several States by one days have a limit or can this be a big number of values?

     

    Using the legend by state the chart has you refer groups the information together by the same states so not giving you the expected result.

     

    One option I can see is to have a column that you make unique ID by status and sort number so that you can use in the leggend however with this option you would need to change all the colours of the datapoints by hand and if they are a lot it will hard work.