(+351) 21 24 10006  ·  info@bconcepts.pt
Carnaxide, Lisbon

How to create conditional visualizations in Copilot in Power BI

João Barros 19 de November de 2026 4 min read

This tutorial shows how to create conditional visualizations in Copilot in Power BI, that is, configure charts that automatically change according to prompts and defined rules. It is useful for interactive reports where users want to see different formats or metrics based on natural language questions or business conditions.

Prerequisites

  • Account with access to Power BI and Copilot enabled.
  • Existing Power BI report with a table or data model (can be a .pbix).
  • Basic measures in DAX for the metrics you want to present (e.g.: TotalSales, Quantity).
  • Permissions to edit the report and publish to the Power BI service (optional).

Step 1: Prepare measures and support columns

Create the DAX measures that will be used in the conditional visualizations. It is important to have clear measures so Copilot can recognize them when asked for a change. Minimum example for sales:

TotalSales = SUM(Sales[SalesAmount])
TotalQuantity = SUM(Sales[Quantity])
SalesYTD = TOTALYTD([TotalSales], 'Date'[Date])

Add a calculated column as well if you need conditional categories (e.g.: growth band).

GrowthCategory =
VAR pct = DIVIDE([TotalSales] - [TotalSalesPrevPeriod], [TotalSalesPrevPeriod])
RETURN
SWITCH(TRUE(),
  pct > 0.2, "Alto",
  pct > 0.05, "Médio",
  "Baixo")

Step 2: Create base visuals in the report

Insert the visuals that will serve as the basis for conditional variations: bar chart, line chart and card. Name them clearly in the Visualizations pane so Copilot can identify them (e.g.: "Vendas_Barras", "Vendas_Linha").

Step 3: Write example prompts for Copilot

Copilot responds better with examples. Create a prompts document or use the comments pane in the Power BI Service. Example prompts you will use:

Mostrar Vendas_Mensais como gráfico de linha quando o utilizador pedir tendência.
Se GrowthCategory = "Alto", destacar a cor das barras para verde.
Exibir cartão com TotalSales e subtítulo com SalesYTD quando pedir resumo.

Step 4: Use Copilot to transform visuals

In the Power BI Service or Desktop, open Copilot and paste one of the prompts. For example: "Transforma Vendas_Barras para realçar em verde quando GrowthCategory for Alto". Copilot will analyze the model and suggest formatting or filter changes.

Step 5: Validate and adjust conditional rules

After Copilot applies the changes, check the visual's Format property. Adjust conditional formatting rules if necessary: go to Data colors > Conditional formatting and configure by Field value pointing to the column or measure that defines the condition.

-- Exemplo conceptual de format by measure (configurável via UI, não código DAX direto)
Field for color = IF([GrowthCategory] = "Alto", "#2ECC71", IF([GrowthCategory] = "Médio", "#F1C40F", "#E74C3C"))

Step 6: Create a conversational prompt for end users

Build a prompt that users can use in the pane with natural language. Useful examples: "Show sales trend for the last 12 months" or "Highlight products with high growth". Test several prompts and refine so Copilot always applies the correct conditional visuals.

Verify the result

Confirm that the visualizations change according to the prompts and rules: ask Copilot to apply one of the example prompts and see if the chart changes type, filter, or color automatically. Validate with test data that the conditions (e.g.: GrowthCategory = Alto) actually change the color/format of the visual.

Conclusion

You can now use Copilot in Power BI to create conditional visualizations that change type, color and filters with prompts. Next steps: automate publishing with controlled versions, add parameters for more control and train users with standard prompts. Tip: keep visuals and measure names clear so Copilot can find and apply rules more accurately.