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).
Python script not working on Power BI server
Hi, I have some reports published to the Power BI server. Some of their visuals come from python scripts. They look fine on the Power BI desktop, but when I publish them to the server, I get Python visual errors. It was fine a few weeks ago with the same code. Does anyone else have the same problem? Any ideas? ThanksCreating 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 ?Need a horizontal funnel chart
Hi members, I am looking for a way to visualize a funnel horizontally. I have been looking into the 'horizontal funnel by MAQ' but that one is not useful for me. Default PBI visual for a funnel has all the options that I need, except that it is not horizontal. Any ideas are welcome. Thank you very much in advance! Kind regards, KayaReport Server Error on Python Visual
I have deveoped a Power BI report with a python visual which works fine in desktop but when i save to the Report Server I get the following error when opening the report from the web portal: "Python visuals are currently disabled in your organisation." Yet, unlike Power BI Services, there is no option to enable / disable python scripts in Report Server. Does anyone know a workaround? Many Thanks
