Step 1: Open VS code and open PBI project folders
Step 2: write the following
Open semantic model from PBIP folder 'D:\TMDL_Folder.SemanticModel'.
or
write / and select Open semantic model from PBIP folder then past the path to the folder and hit enter
Step 3: paste the following prompt
Goal:
Create executive dashboards, Financial, Merchant, Customer dashboards and detailed pages, and tooltips
Read the semantic model and all folders content completly, then, Add any relevant and required scripts, tables, fields, and Measures to Generate:
Necessary measures table and folders
Calendar Table
Dashboards layout
Slicers
KPIs (value, trend, and target), Gauge cards, and all applicable visualization and Conditional formatting rules.
Tooltips
Drill-through pages
DAX code
Include all applicable KPIs for Revenue, Expense, Growth, like:
Revenue Growth %
Gross Profit
Net Profit
Profit Margin %
Transaction Value
Transaction Count
Average Transaction Value
Success Rate %
Week Over Week (WoW), Month Over Month (MoM), and Year Over Year (YoY) comparisons
MTD, QTD, YTD, WTD, MoM, QoQ, YoY, WoW, FYTD, PY, LY, CY, CM, PM, CQ, PQ
Before editing, inspect the current files and preserve unrelated user changes. Generate or modify JSON with a structured serializer, not hand-built JSON strings. Afterward, parse every report JSON file and validate it against its schema. Check nested visual.objects arrays and objects for balanced braces and brackets. Don’t claim the PBIP is ready until validation passes; if Power BI Desktop is available, open the project and confirm it loads.
