Line Chart - 2 budgets 1 Node

[daledale]

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!

[mwegener]

Hi @daledale 

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[mwegener]

Hi @daledale,

did you solve your problem?

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[daledale]

Sorry for the aweful delay! 
YES! THIS IS IT! Thanks a lot!

[mwegener]

If I answered your question, please mark my post as solution, this will also help others.

[amitchandak]

Not sure I got it completely. But if you put the budget in legend, then it should show two line. 

[daledale]

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.

[mwegener]

Hi @daledale ,

maybe you could create a calculated column (Category & Node) and use it in the legend.

CATEGORY_NODE = CONCATENATE('Table'[CATEGORY],'Table'[NODE])

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[daledale]

Thanks again, but what I need is to show them as 2 different lines when I filter by Node.
Meaning, I want to filter Node 1, and see a line for Category A, and a line for Category B.

[mwegener]

So?

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[daledale]

@mwegener sorry, I might not be expressing myself correctly. 

Maybe with Screenshots it's easier:

Node = Nodo
Category = SDO
My Node of Brasil has both sub categories. But when I filter only by Node, it adds up both:

Filtering by Node and Category AFiltering by Node and Category BFiltering only by Node shows added up both

I hope this claryfies my issue, Thanks again for the support!

[mwegener · Accepted solution]

Hi @daledale,

check this out.

CATEGORY_NODE = 'Table'[Nodo] & ", " & 'Table'[SDO] 

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[mwegener]

Hi @daledale ,

could you share sample data or a PBIX File?