Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Myllena
Frequent Visitor

How to dynamically generate multiple line values in a stacked column and line chart without creating

Olá a todos,

Estou enfrentando um desafio com um gráfico de colunas e linhas empilhadas no Power BI.

A cada mês, preciso adicionar um novo valor de linha ao gráfico (além das colunas empilhadas), mas atualmente tenho que criar uma nova medida manualmente para cada linha toda vez que um novo mês chega.

Estou procurando uma maneira de gerar dinamicamente esses valores de linha sem precisar atualizar ou criar manualmente uma nova medida a cada mês. Idealmente, eu gostaria de usar uma dimensão ou algum outro método que permita que o gráfico reflita automaticamente várias séries de linhas com base nos dados.

Existe uma prática recomendada ou solução alternativa para esse cenário?

Imagem 1: Medidas manuais criadas mensalmente
Cada linha no gráfico é baseada em uma medida criada manualmente para cada mês. Isso se torna demorado e difícil de manter ao longo do tempo.

Captura de tela 2025-04-09 140615.png

Figura 2: Tentativa de criar linhas dinamicamente
Tentando gerar valores de linha dinamicamente usando uma única medida ou dimensão, mas o visual não separa as linhas corretamente.


Captura de tela 2025-04-09 140545.pngDesde já, obrigado!

1 ACCEPTED SOLUTION

Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

View solution in original post

11 REPLIES 11
v-venuppu
Community Support
Community Support

Hi @Myllena ,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please accept it as a solution and give it a 'Kudos' so other community members with similar problems can find a solution faster.

Thank you.

v-venuppu
Community Support
Community Support

Hi @Myllena ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

v-venuppu
Community Support
Community Support

Hi @Myllena ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

Regards,
Rama U.

 

v-venuppu
Community Support
Community Support

Hi @Myllena ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

Regards,

Rama U.

I still haven't been able to solve it, with no solution so far.

Hi @Myllena ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @lbendlin for the prompt response.

 

Can you please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided as suggested by Ibendlin so that it will be helpful for us to reporoduce the solution.

 

Regards,

Rama U.

 

 

 

 

lbendlin
Super User
Super User

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Sample data for better understanding:
(Each "ARQUIVO FONTE" represents a different dataset with "REALIZADO" and "PO" values for each date.)

ARQUIVO FONTEREALIZADOPODATAATRIBUTO
PO-01-25102001/01/2025CO2
PO-01-25102001/02/2025CO2
PO-01-25102001/03/2025CO2
PO-01-25102001/04/2025CO2
PO-01-25102001/05/2025CO2
PO-01-25102001/06/2025CO2
PO-01-25102001/07/2025CO2
PO-01-25102001/08/2025CO2
PO-01-25102001/09/2025CO2
PO-01-25102001/10/2025CO2
PO-02-25102101/01/2025CO2
PO-02-25102101/02/2025CO2
PO-02-25102101/03/2025CO2
PO-02-25102101/04/2025CO2
PO-02-25102101/05/2025CO2
PO-02-25102101/06/2025CO2
PO-02-25102101/07/2025CO2
PO-02-25102101/08/2025CO2
PO-02-25102101/09/2025CO2
PO-02-25102101/10/2025CO2

What I want:

  • The "REALIZADO" values to appear as stacked columns.

  • The "PO" values to appear as separate line series, one for each "ARQUIVO FONTE", without needing to manually create a new measure for each file every time.

I'm trying to achieve this dynamically, but so far I haven't found a way to make the line values split automatically.

Why  a stacked column for REALIZADO ?  These are only single values.

 

You could use Small Multiples to separate out the ARQUIVO FONTE.

 

lbendlin_0-1744226959359.png

 

I need a visualization in this format to compare the PO values with the "REALIZADO". There are many different POs — I only included two here as an example.

Myllena_0-1744228308322.png

 

Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.