Forum Discussion
How to dynamically generate multiple line values in a stacked column and line chart without creating
Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
Super UserPlease 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-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Sample data for better understanding:
(Each "ARQUIVO FONTE" represents a different dataset with "REALIZADO" and "PO" values for each date.)
| ARQUIVO FONTE | REALIZADO | PO | DATA | ATRIBUTO |
| PO-01-25 | 10 | 20 | 01/01/2025 | CO2 |
| PO-01-25 | 10 | 20 | 01/02/2025 | CO2 |
| PO-01-25 | 10 | 20 | 01/03/2025 | CO2 |
| PO-01-25 | 10 | 20 | 01/04/2025 | CO2 |
| PO-01-25 | 10 | 20 | 01/05/2025 | CO2 |
| PO-01-25 | 10 | 20 | 01/06/2025 | CO2 |
| PO-01-25 | 10 | 20 | 01/07/2025 | CO2 |
| PO-01-25 | 10 | 20 | 01/08/2025 | CO2 |
| PO-01-25 | 10 | 20 | 01/09/2025 | CO2 |
| PO-01-25 | 10 | 20 | 01/10/2025 | CO2 |
| PO-02-25 | 10 | 21 | 01/01/2025 | CO2 |
| PO-02-25 | 10 | 21 | 01/02/2025 | CO2 |
| PO-02-25 | 10 | 21 | 01/03/2025 | CO2 |
| PO-02-25 | 10 | 21 | 01/04/2025 | CO2 |
| PO-02-25 | 10 | 21 | 01/05/2025 | CO2 |
| PO-02-25 | 10 | 21 | 01/06/2025 | CO2 |
| PO-02-25 | 10 | 21 | 01/07/2025 | CO2 |
| PO-02-25 | 10 | 21 | 01/08/2025 | CO2 |
| PO-02-25 | 10 | 21 | 01/09/2025 | CO2 |
| PO-02-25 | 10 | 21 | 01/10/2025 | CO2 |
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.
- lbendlin
Why a stacked column for REALIZADO ? These are only single values.
You could use Small Multiples to separate out the ARQUIVO FONTE.
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.
- lbendlin
Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.