Showing results for 
Search instead for 
Did you mean: 
New Member

How to configure and create KPI with python in Power BI using dynamic table

I want to create a dashboard using dynamic table where columns are not consistent.

For example: Lets say initially, we are getting five columns (A, B C, D, E) from an excel sheet. But after next refresh, we will have three columns (A, C, D). The KPIs will be enabled/disabled based on available columns. I want to configure this dynamic table using python and create the KPIs with python libraries so that I can use conditions for the KPI. I have tried using the python visual but no luck so far. 


Any help on this thread will be appreciated.


Helpful resources

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.