Needing help Create custom parallel interactive bar chart
I need help with creating the middle chart The dashboard looks like butterfly chart for hires and exits, with a parallel bar chart in the middle showing headcount and promotions for each headcount grade level -as Power BI lacks this visual I am trying to do it with python but I am unable to find the right code to generate the middle graph and make it interactive with the bar charts on the left and right. ** so the requirement is creating three subplots: left for hires for each career level, middle for headcount/promotions for each career level *up of each other* in parallel and showing the (number, percentage ), and right for exits, all sharing the same y-axis (career levels).
[help] sankey image can't be displayed in poweBI
Hi team, I have below script. import pandas as pd import chart_studio.plotly as py import plotly.graph_objects as go labelListTemp1 = list(set(dataset.source.values)) labelListTemp2 = list(set(dataset.target.values)) labelList = labelListTemp1 + labelListTemp2 sankey_node = list(dict.fromkeys(labelList)) fig = go.Figure(data=[go.Sankey( node = dict( pad=15, thickness=20, line = dict(color = "black", width = 0.5), label = labelList, color = "blue" ), link = dict(source = dataset.source.apply(lambda x: labelList.index(x)), target = dataset.target.apply(lambda x: labelList.index(x)), value = dataset.value))]) fig.show() And I run it in powerBI with enabling python script. but the result is that the code opened a browser and displayed the sankey in browser, instead of in powerBI. 1. the code opened a browser and displayed the sankey in browser. 2. I would like the sankey chart displayed in powerBI, but powerBI says that 'the visual can't be displayed'. Is there anyone that succesfully created sankey chart by python plotly lib? can any expert help take a look what's wrong here? Thanks, CheriePlans to support plotly (Python package)?
Hi there, In the Python library, plotty, I do und some lovely looking box plots where I'm able to display the underlaying data (see here). I got REALLY excited as this is exactly what I need in my powerbi report. Buuuuut unfortunately according to this Microsoft doc , the plotty library is still not supported. Question 1: does anyone know if plotly is on the Microsoft radar to support? Question 2: Anyone had experience with another Python package that could give me a similar picture as the below? (Or even R).Creating Python Visuals
Hi, Hoping someone can help me. I'm trying to create a custom Python visual (ridge plot) using the following fields : (The Compliance (data type: Text) and Assignment Number (data type: Text) fields are from 2 different tables) # The following code to create a dataframe and remove duplicated rows is always executed and acts as a preamble for your script: dataset = pandas.DataFrame(Compliance, Assignment Number) dataset = dataset.drop_duplicates() import seaborn as sns import matplotlib.pyplot as plt import pandas as pd # Paste or type your script code here: ridge_plot = sns.FacetGrid(dataset, row="Compliance", hue="Compliance", aspect=5, height=1.25) # Use map function to make density plot in each element of the grid. ridge_plot.map(sns.kdeplot, "Assignment Number", clip_on=False, shade=True, alpha=0.7, lw=4, bw_method=.2) ridge_plot.map(plt.axhline, y=0, lw=4, clip_on=False) ridge_plot.savefig("Ridge_plot.png") When I try to create the visual, I get the below error: I have two questions: Can I create a dataset, for my Python custom visual, from 2 tables that have a one-many relationship ? Also do you know why I'm getting the above error ? Many thanks Also do you know why I'm getting the above error ?
