Forum Discussion
Line Chart - 2 budgets 1 Node
Hi everyone,
I'm trying to create a line chart that change with according 2 slicers.
One slicers contains Nodes (1,2,3,4, etc...).
The other one contains Budgets (A, B, C, etc...)
The line chart shows me the added value of A+B when I select the Node (1). And shows me the behaviour of the budget once I select it, be it A or B or whatever.
But when I want to see Budget A and B at the same time, it only shows as 1 line, and I'd need them to show separately.
Is there a way to do that?
Thanks!
12 Replies
Not sure I got it completely. But if you put the budget in legend, then it should show two line.
Sorry for my late reply, I'm really stucked with this PBI and need to solve many issues I cannot find solutions for..
This is the way I have my tables (it's actually an unpivotted table)
NODE - CATEGORY - COUNTRY - ATTRIBUTE - VALUE
1 A XX Q1 $$1 B XX Q1 $$
2 A XXXX Q1 $$
2 B XXXX Q1 $$
And so on...
I have 2 slicers, which I use to filter my line charts.
1 is for NODEs, one is for CATEGORY.
If I filter by Category, I'm ok. Because I see a line for Category A, belonging to NODEs 1, 2, etc...
But if I filter by NODE, it shows me A+B as only one line in the chart.
Right now I have the NODEs in my legend and Attributes in my Axis.
