query-design Skill
Separates DAX data-fetching from TypeScript presentation. Guides when to use DAX vs. TypeScript vs. Vega-Lite for aggregation, total rows, FORMAT(), SELECTCOLUMNS, BLANK handling, filtering, multi-grain queries, cross-filtering and cross-highlight subset/overlay queries, and format strings. Published by microsoft in fabric-apps-analytic-templates.
What is query-design Skill?
Separates DAX data-fetching from TypeScript presentation. Guides when to use DAX vs. TypeScript vs. Vega-Lite for aggregation, total rows, FORMAT(), SELECTCOLUMNS, BLANK handling, filtering, multi-grain queries, cross-filtering and cross-highlight subset/overlay queries, and format strings. Published by microsoft in fabric-apps-analytic-templates. This profile combines repository metadata with install, compatibility, and usage signals so developers can quickly decide whether it fits their agent workflow before opening the source repository.
Automated repository signals based on public metadata such as recency, license, installation evidence, and adoption. These are not a security audit or endorsement.
Key capabilities
- Includes SKILL.md support
- Reusable instructions support
- Data analysis
- Design and media
- Data analysis use cases
- Design and media use cases
Technical details
- Install or run with Copy skill directory
When to use query-design Skill
- Use it for data analysis.
- Use it for design and media.
Built with
Editorial notes
Source
- Creator: microsoft
- Repository: microsoft/fabric-apps-analytic-templates
- Skill file: .agents/skills/query-design/SKILL.md
What it does
Separates DAX data-fetching from TypeScript presentation. Guides when to use DAX vs. TypeScript vs. Vega-Lite for aggregation, total rows, FORMAT(), SELECTCOLUMNS, BLANK handling, filtering, multi-grain queries, cross-filtering and cross-highlight subset/overlay queries, and format strings.
Skill instructions
Query Design — Separation of Data and Presentation DAX computes and fetches data. TypeScript shapes it for display. VegaVisual and DataGrid render it. Aggregate in DAX to the visual's grain — never fetch lower-grain rows to roll up client-side. Once at the visual's grain, TypeScript can derive simple totals (SUM, COUNT, MIN, MAX) from the already-fetched detail rows. When a visual layout changes, only the TypeScript or spec layer should change — not the DAX query. Responsibility Matrix | Concern | Owner | |---|---| | Semantic measures (SUM, DISTINCTCOUNT, etc.) | DAX | | Filters and slicers | DAX or TypeScript (see Filter Strategy) | | Grouping grain (SUMMARIZECOLUMNS) | DAX | | Time intelligence (YTD, YoY) | DAX | | TopN / payload reduction | DAX | | Deterministic row ordering (ORDER BY) | DAX (for debugging — not presentation sort) | | Merging multiple result sets | TypeScript | | Totals derivable from detail rows (SUM, COUNT, MIN, MAX) | TypeScript (roll up from already-fetched deta
Explore related resources
Frequently asked questions
What is query-design?
query-design is a open-source AI agent skill with Copy skill directory. Separates DAX data-fetching from TypeScript presentation. Guides when to use DAX vs. TypeScript vs.
Who is query-design best for?
query-design is best for reusing agent instructions, scripts, and references, data analysis workflows, design and media workflows.
How do I install query-design?
Install or run query-design using Copy skill directory. Check query-design for the latest setup command.
Is query-design actively maintained?
query-design may need a closer maintenance check before production use.
Auto-fetched from GitHub.
