https://community.fabric.microsoft.com/t5/Developer/How-to-configure-and-create-KPI-with-python-in-Power-BI-using/m-p/3049017#M40952 <P>I want to create a dashboard using dynamic table where columns are not consistent.</P><P>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.&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 302px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/863101i8E3FB7ABA0BC817A/image-dimensions/302x172?v=v2" width="302" height="172" role="button" title="image.png" alt="image.png" /></span></P><P>Any help on this thread will be appreciated.</P> Sun, 29 Jan 2023 16:38:08 GMT Sharika_Natasha 2023-01-29T16:38:08Z https://community.fabric.microsoft.com/t5/Developer/How-to-configure-and-create-KPI-with-python-in-Power-BI-using/m-p/3049017#M40952 <P>I want to create a dashboard using dynamic table where columns are not consistent.</P><P>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.&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 302px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/863101i8E3FB7ABA0BC817A/image-dimensions/302x172?v=v2" width="302" height="172" role="button" title="image.png" alt="image.png" /></span></P><P>Any help on this thread will be appreciated.</P> Sun, 29 Jan 2023 16:38:08 GMT https://community.fabric.microsoft.com/t5/Developer/How-to-configure-and-create-KPI-with-python-in-Power-BI-using/m-p/3049017#M40952 Sharika_Natasha 2023-01-29T16:38:08Z