How to reproduce a visual in PowerBI with Python Plotly and dash?

Hello guys!
I have a matrix visual for a production line made in PowerBI but I need to reproduce this visual using only Python to treat the relational database (firebird) .
I am using Dash_Datatable,
pandas and sqlalchemy.
Can anyone help me find the way to reproduce this structure?

Hello @NOVOSYS,

It looks like it is possible, at least the conditional formatting that you are using on the table.

Check out:

With this, you should be able to get in the ballpark. :slight_smile:

As far as the merged rows, I only think that merging columns is supported at this time. However, there may be a way to manipulate it through Javascript and CSS so that repeated row info is merged. :slight_smile:

1 Like

Thank you very much.
The part referring to the conditionals I was already aware of but I needed to know about the visual itself, in addition to uniting the repeated lines I need to know how to generate the calculated columns in the dataframe to plot the dash_datatable

How do you mean? Create the visuals?

Like copy the drop-downs at the top that filter?
And the calculated fields you can do in the dataframe before you provide the table. Though, Iā€™m not sure I know what your calculated fields are.

1 Like

When I say visual Iā€™m referring to the format of the repeated lines grouped as you said.
This matrix shows a production process where from the drawing to the last field are calculated columns showing the input and output balance of the process and the conditional color represents specifications of the client factory

Currently, with dash_tables, this is not possible on the rows. However, you could manage this with javascript and css. If you have an example dataset, I may be able to help you with this.

These will need to be calculated on the python side when adjusting the dataframe.